Bug 1362400

Summary: Informix - time values are adjusted in "opposite direction"
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Juraj Duráni <jdurani>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED WONTFIX QA Contact: Juraj Duráni <jdurani>
Severity: high Docs Contact:
Priority: high    
Version: 6.3.0CC: aszczucz, blafond, drieden, jolee, mbaluch, thauser
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-08-08 13:14:09 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 2016-08-02 06:53:48 UTC 
Description of problem:
If translator property _DatabaseTimeZone_ is set, time values are adjusted in "opposite direction" (in compare with date and timestamp values). Note, that I did not change user.timezone system property of the server.


> Query
SELECT intkey,timevalue,datevalue,timestampvalue FROM source.smalla WHERE intkey = 0
> DatabazeTimeZone=GMT-02
IntKey TimeValue DateValue  TimestampValue
0      22:00:00  2000-01-01 2000-01-01 03:00:00.0
> DatabazeTimeZone=GMT-01
IntKey TimeValue DateValue  TimestampValue
0      23:00:00  2000-01-01 2000-01-01 02:00:00.0|
> DatabazeTimeZone=GMT+00
IntKey TimeValue DateValue  TimestampValue
0      00:00:00  2000-01-01 2000-01-01 01:00:00.0|
> DatabazeTimeZone=GMT+01
IntKey TimeValue DateValue  TimestampValue
0      01:00:00  2000-01-01 2000-01-01 00:00:00.0|
> DatabazeTimeZone=GMT+02
IntKey TimeValue DateValue  TimestampValue
0      02:00:00  1999-12-31 1999-12-31 23:00:00.0|

> DDL
CREATE FOREIGN TABLE SmallA (...
    DateValue date OPTIONS (NATIVE_TYPE 'date', NAMEINSOURCE 'datevalue'),
    TimeValue time OPTIONS (NATIVE_TYPE 'datetime hour to fraction(1)', NAMEINSOURCE 'timevalue'),
    TimestampValue timestamp OPTIONS (NATIVE_TYPE 'timestamp', NAMEINSOURCE 'timestampvalue'),
...
Comment 1 JBoss JIRA Server 2016-08-02 11:25:41 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-4364 to Resolved