Bug 1164281 - Excel Translator Wrong Result From Columns With Interleaved Null Values
Summary: Excel Translator Wrong Result From Columns With Interleaved Null Values
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.1.0
Hardware: x86_64
OS: Linux
unspecified
unspecified
Target Milestone: ER5
: 6.1.0
Assignee: Van Halbert
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-11-14 14:38 UTC by Jan Stastny
Modified: 2016-02-10 08:55 UTC (History)
2 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2016-02-10 08:55:03 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-3219 0 Major Closed Excel Translator Wrong Result From Columns With Interleaved Null Values 2015-10-08 14:39:55 UTC

Description Jan Stastny 2014-11-14 14:38:18 UTC
When querying a column which has a null value (empty cell) 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.

Affected version:
DV 6.1.0 ER4

Steps to reproduce:
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.

Comment 1 JBoss JIRA Server 2014-11-19 21:37:47 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-3219 to Resolved

Comment 2 JBoss JIRA Server 2015-10-08 14:39:55 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-3219 to Closed


Note You need to log in before you can comment on or make changes to this bug.