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 Components: Misc. Connectors Affects Versions: 9.3 Reporter: Lucie Fabrikova Assignee: Steven Hawkins Priority: Critical Fix For: 10.0, 8.12.x-6.4, 9.3.4, 9.2.7 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