[teiid-issues] [JBoss JIRA] (TEIID-4668) Google translator skips NULL value in INSERT
Johnathon Lee (JIRA)
issues at jboss.org
Fri Feb 17 16:36:00 EST 2017
[ https://issues.jboss.org/browse/TEIID-4668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Johnathon Lee updated TEIID-4668:
---------------------------------
Fix Version/s: 8.12.10.6_3
> Google translator skips NULL value in INSERT
> --------------------------------------------
>
> Key: TEIID-4668
> URL: https://issues.jboss.org/browse/TEIID-4668
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.8.6_3
> Reporter: Lucie Fabrikova
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 9.0.6, 9.1.2, 9.2, 8.12.10.6_3
>
> Attachments: google-crud.png, googlespreadsheetcrud-vdb.xml
>
>
> I have google spreadsheet table smalla with defined header columns intkey, intnum and other (see attached screenshot).
> Following query doesn't insert NULL value to column intnum:
> INSERT INTO smalla(intnum, intkey) values (null, 562)
> Instead, it inserts 562 to intnum and NULL to intkey.
> (Server log shows no exception)
> INSERT works correctly if none of the inserted values is NULL.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
More information about the teiid-issues
mailing list