[teiid-issues] [JBoss JIRA] (TEIID-4668) Google translator skips NULL value in INSERT

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-4668:
----------------------------------
    Fix Version/s: 9.0.6
                   9.1.2
                   9.2
         Priority: Blocker  (was: Major)


Updating to blocker since this corrupts the insert.

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