Bug 1164281

Summary: Excel Translator Wrong Result From Columns With Interleaved Null Values
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Jan Stastny <jstastny>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.1.0CC: dlesage, vhalbert
Target Milestone: ER5Keywords: QA-Closed
Target Release: 6.1.0   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
The Excel translator was producing the wrong result from columns with interleaved null values. When querying a column which has a null value (empty cell) somewhere in it, the result set was missing all the rows under the null value in the xlsx file. This has now been fixed so that the complete result set is returned.
 Story Points: ---
Clone Of: Environment:
Last Closed: 2016-02-10 08:55:03 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

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