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

Google translator string empty cell is evaluated as NULL

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 9.1
    • Component/s: Documentation
    • Labels:
      None
    • Steps to Reproduce:
      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

      Description

      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

        Gliffy Diagrams

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: