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

Google translator string empty cell is evaluated as NULL

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 9.1
    • None
    • Documentation
    • None
    • Hide
      • in dynamic vdb, create a foreign table sheetName with column definition: A string(10) OPTIONS (NATIVE_TYPE 'STRING')
      • in a google spreadsheet, leave empty cell in column A
      • execute query "select A from sheetName" - returns NULL value instead of empty string
      Show
      in dynamic vdb, create a foreign table sheetName with column definition: A string(10) OPTIONS (NATIVE_TYPE 'STRING') in a google spreadsheet, leave empty cell in column A execute query "select A from sheetName" - returns NULL value instead of empty string

      In documentation [1] is said "Any non-string column with an empty cell has the value retrieved as null, otherwise it is the empty string." however empty cell of string column is evaluated as NULL instead of empty string.

      [1] https://teiid.gitbooks.io/documents/content/reference/Google_Spreadsheet_Translator.html
      [2] https://access.redhat.com/documentation/en/red-hat-jboss-data-virtualization/6.3/paged/development-guide-volume-3-reference-material/1314-google-spreadsheet-translator

            rhn-engineering-shawkins Steven Hawkins
            lfabriko@redhat.com Lucie Krejcirova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: