Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4668

Google translator skips NULL value in INSERT

    Details

      Description

      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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                lfabriko Lucie Fabrikova
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: