Bug 1362400 - Informix - time values are adjusted in "opposite direction"
Summary: Informix - time values are adjusted in "opposite direction"
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.3.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: ---
Assignee: Van Halbert
QA Contact: Juraj Duráni
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-08-02 06:53 UTC by Juraj Duráni
Modified: 2016-08-08 13:14 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-08-08 13:14:09 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-3808 0 Major Resolved Informix translator - date/time/timestamp values are adjusted differently according to timezone 2016-08-15 03:15:53 UTC

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


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