[teiid-issues] [JBoss JIRA] (TEIID-3219) Excel Translator Wrong Result From Columns With Interleaved Null Values

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13021389#comment-13021389 ] 

Ramesh Reddy commented on TEIID-3219:
-------------------------------------

I believe any of the test documents we have should show the behavior. Otherwise they may have had some fixes in 3.10 version in regards to that.

> I thought by look ahead you meant more rows, then we are saying the same thing.
the tricky thing in this test document is, there are many cells, but table is picking up that single cell as column. So, for this case we have information only about that cell, so we can iterate only on that.

> Excel Translator Wrong Result From Columns With Interleaved Null Values
> -----------------------------------------------------------------------
>
>                 Key: TEIID-3219
>                 URL: https://issues.jboss.org/browse/TEIID-3219
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.7.1
>            Reporter: Jan Stastny
>            Assignee: Kylin Soong
>             Fix For: 8.7.1, 8.10
>
>         Attachments: artifacts.zip
>
>
> 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.



--
This message was sent by Atlassian JIRA
(v6.3.8#6338)