Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5060

Infinispan Hotrod Translator UPDATE on primary key column

    XMLWordPrintable

Details

    Description

      UPDATE query where the PRIMARY KEY of the table is being changed succeeds, returns update count of corresponding rows, but the changes don't get promoted to actual cache.

      Consider

      UPDATE query
      UPDATE SmallA SET StringKey = 100 WHERE IntKey > 25
      

      where StringKey is set as PRIMARY KEY and 6 rows fulfill the filter on IntKey>25.

      When this UPDATE is performed, returned number of rows update is 6, but the contents of the cache don't change.

      There are several applicable resolutions:

      1. There should be error thrown by Teiid, that this is not allowed operation
      2. There should be update count 0 returned
      3. There should be change in JDG cache, effectively squashing the 6 rows into single one
      4. There should be error thrown by Teiid, that there is duplicate PK value (this is not something Teiid usually enforces)

      Attachments

        Activity

          People

            rhn-engineering-rareddy Ramesh Reddy
            jstastny@redhat.com Jan Stastny
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: