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

Infinispan Hotrod Translator UPDATE on primary key column

XMLWordPrintable

      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)

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

                Created:
                Updated:
                Resolved: