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

Infinispan Hotrod Translator UPDATE on primary key column

    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)

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                rareddy Ramesh Reddy
                Reporter:
                jstastny Jan Stastny
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: