Jan Stastny created TEIID-5162: ---------------------------------- Summary: Google Spreadsheet translator after update unaffected columns are set to null Key: TEIID-5162 URL: https://issues.jboss.org/browse/TEIID-5162 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.x-6.4 Reporter: Jan Stastny Assignee: Steven Hawkins Priority: Blocker There is loss of data when performing update on Google Spreadsheet. Initial data: {code:sql} INSERT INTO SmallA_Direct (IntKey, StringKey, IntNum, StringNum) VALUES (1, '1', 1, '1'), (2, '2', 2, '2'), (3, '3', 3, '3'), (4, '4', 4, '4'), (5, '5', 5, '5') {code} Then a {code}SELECT * FROM SmallA_Direct{code} results in: |1|1|1|1| |2|2|2|2| |3|3|3|3| |4|4|4|4| |5|5|5|5| Following update: {code:sql} UPDATE SmallA_Direct SET IntNum = NULL WHERE IntNum >= 3 {code} Results in following data returned by {code}SELECT * FROM SmallA_Direct{code}: |1|<null>|1|<null>| |2|<null>|2|<null>| |3|3.0|<null>|3.0| |4|4.0|<null>|4.0| |5|5.0|<null>|5.0| -- This message was sent by Atlassian JIRA (v7.5.0#75005)