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

[Lucie Fabrikova (JIRA)]

Lucie Fabrikova created TEIID-4668:
--------------------------------------

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