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

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-3219:
---------------------------------------

> take any document, just scroll empty doc and save and test.

I don't see that behavior with OpenOffice.  Did you see that with Excel?

> I did mean entire row, not just one column. In this usecase he had only single column, that constitutes as entire row.

Sorry I thought by look ahead you meant more rows, then we are saying the same thing.


> 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)