Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1138715

Summary:	Excel translator is not able to manage WHERE clause with time value
Product:	[JBoss] JBoss Data Virtualization 6	Reporter:	Juraj Duráni <jdurani>
Component:	Teiid	Assignee:	Van Halbert <vhalbert>
Status:	CLOSED CURRENTRELEASE	QA Contact:
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	6.1.0	CC:	dlesage, felias, vhalbert
Target Milestone:	ER3	Keywords:	QA-Closed
Target Release:	6.1.0
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:	The Excel translator was not able to manage a WHERE clause with a time value. This was because the engine built the java.sql.Time instance from Epoach, whereas the java.sql.Time object that is built in Excel is from a date type that Apache POI returns. Even though the time value would be correct the date value was not, thus they did not match. The solution was extract the Time-specific value from Excel the instance and build the Time result from that. Hence, bad results are no longer returned to the user.	Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-02-10 08:57:39 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 Juraj Duráni 2014-09-05 13:40:37 UTC

Description of problem:
Excel translator is not able to manage WHERE clause with time value. When I use time value in WHERE clause (with <, >, =) I get bad result. There is no problem with Timestamp and Date.


How reproducible:
I have created source model from Excel file (.xlsx).
But SQL query with time value in WHERE clause retrns bad result.

e.g SELECT IntKey, TimeValue FROM Source.SmallA WHERE TimeValue = '21:00:00' return no result but in excel table are several values with time 21:00:00.

Actual results:


Expected results:


Additional info:

Comment 2 JBoss JIRA Server 2014-09-05 20:59:47 UTC

Ramesh Reddy <rareddy> updated the status of jira TEIID-3118 to Resolved

Comment 3 JBoss JIRA Server 2015-10-08 14:39:55 UTC

Steven Hawkins <shawkins> updated the status of jira TEIID-3118 to Closed