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

Excel Translator Wrong Result From Columns With Interleaved Null Values

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.7.1, 8.10
    • 8.7.1
    • Misc. Connectors
    • None
    • Hide

      1. Create excel spreadsheet with some cells with null values. Ideally a few rows should follow the null-valued cells.
      2. Create and deploy vdb
      3. Query the vdb selecting the columns with some null values
      4. When all the columns in select clause are null, the following rows are not returned.

      Show
      1. Create excel spreadsheet with some cells with null values. Ideally a few rows should follow the null-valued cells. 2. Create and deploy vdb 3. Query the vdb selecting the columns with some null values 4. When all the columns in select clause are null, the following rows are not returned.

    Description

      When querying a column which has a null value somewhere in it, the result set is missing all the rows under the null value in the xlsx file. When querying more columns, the result set is missing some values only if there is a row, where both columns contains null value.

      Attachments

        Activity

          People

            kylinsoong.1214@gmail.com Kylin Soong (Inactive)
            jstastny@redhat.com Jan Stastny
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: