[teiid-issues] [JBoss JIRA] (TEIID-5162) Google Spreadsheet translator after update unaffected columns are set to null
Steven Hawkins (JIRA)
issues at jboss.org
Mon Nov 20 13:33:00 EST 2017
[ https://issues.jboss.org/browse/TEIID-5162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-5162.
-----------------------------------
Resolution: Duplicate Issue
This is a duplicate of TEIID-4870
> 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)
More information about the teiid-issues
mailing list