]
Lucie Fabrikova updated TEIID-4870:
-----------------------------------
Attachment: googlespreadsheetcrud-vdb.xml-direct-trig-up-orig
Google translator unexpected behavior for view update without
trigger
---------------------------------------------------------------------
Key: TEIID-4870
URL:
https://issues.jboss.org/browse/TEIID-4870
Project: Teiid
Issue Type: Bug
Affects Versions: 9.3
Reporter: Lucie Fabrikova
Assignee: Steven Hawkins
Attachments: googlespreadsheetcrud-vdb.xml-direct-trig-up-orig
If there is a view (CRUD.SmallA_Direct) which defines only a subset of foreign table
(Source.SmallA) columns, there needs to be defined a trigger for update to work correctly.
Otherwise unexpected results are returned after executing update:
* for updated rows, it converts String columns of SmallA_Direct to decimal numbers,
* for not updated rows it returns null for String columns