[teiid-issues] [JBoss JIRA] (TEIID-5162) Google Spreadsheet translator after update unaffected columns are set to null

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-5162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-5162.
---------------------------------


> 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)