[teiid-issues] [JBoss JIRA] (TEIID-4263) StringToTimestamp in convert fails during DST transition hour

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-4263:
----------------------------------
    Fix Version/s: 9.0.4


> StringToTimestamp in convert fails during DST transition hour
> -------------------------------------------------------------
>
>                 Key: TEIID-4263
>                 URL: https://issues.jboss.org/browse/TEIID-4263
>             Project: Teiid
>          Issue Type: Bug
>          Components: Common
>    Affects Versions: 8.7.7.6_2
>            Reporter: Guy Davis
>            Assignee: Steven Hawkins
>             Fix For: 9.1, 9.0.4
>
>         Attachments: ArgentinaTest.java
>
>
> Issue is due to [https://github.com/teiid/teiid/blob/master/common-core/src/main/java/org/teiid/core/types/basic/StringToTimestampTransform.java#L66 | this line] in StringToTimestampTransform.java.  In particular, if you pass in a string date for a timestamp at the beginning of the DST transition hour, the result will be an hour in the future or past, so this string comparison fails, throwing TEIID10060 exception.
> Examples include:
> * America/Edmonton  2016-03-13 02:00:00
> * America/Argentina/Buenos_Aires 1991-10-20 00:00:00



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)