[teiid-issues] [JBoss JIRA] (TEIID-4668) Google translator skips NULL value in INSERT
Steven Hawkins (JIRA)
issues at jboss.org
Tue Jan 3 17:22:00 EST 2017
[ https://issues.jboss.org/browse/TEIID-4668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on TEIID-4668 started by Steven Hawkins.
---------------------------------------------
> Google translator skips NULL value in INSERT
> --------------------------------------------
>
> Key: TEIID-4668
> URL: https://issues.jboss.org/browse/TEIID-4668
> Project: Teiid
> Issue Type: Bug
> 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
>
> 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