Bug 1138715 - Excel translator is not able to manage WHERE clause with time value
Summary: Excel translator is not able to manage WHERE clause with time value
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.1.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ER3
: 6.1.0
Assignee: Van Halbert
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-09-05 13:40 UTC by Juraj Duráni
Modified: 2016-02-10 08:57 UTC (History)
3 users (show)

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.
Clone Of:
Environment:
Last Closed: 2016-02-10 08:57:39 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-3118 0 Major Closed Excel translator is not able to manage WHERE clause with time value 2017-02-15 11:54:05 UTC

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
Note You need to log in before you can comment on or make changes to this bug.