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

Google translator string empty cell is evaluated as NULL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • 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

    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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: