[teiid-issues] [JBoss JIRA] (TEIID-4428) Timestamp having 02:XX:XX as time cannot be cast to timestamp when timezone is CET and summertime

[dalex dalex (JIRA)]

dalex dalex created TEIID-4428:
----------------------------------

             Summary: Timestamp having 02:XX:XX as time cannot be cast to timestamp when timezone is CET and summertime
                 Key: TEIID-4428
                 URL: https://issues.jboss.org/browse/TEIID-4428
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: 8.12.x
         Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA
teiid-9.0.3 on WildFly Full 9.0.2.Final
            Reporter: dalex dalex
            Assignee: Steven Hawkins
            Priority: Blocker


Running the following query:
{code:sql}
select cast ( '2015-03-29 02:20:09' as timestamp )
{code}

I get such exception:
{code}
2016-09-06 14:33:08,868 WARN  [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue15) dxYkAB2TdWA6 TEIID30020 Processing exception for request dxYkAB2TdWA6.5 'TEIID30328 Unable to evaluate convert('2015-03-29 02:20:09', timestamp): TEIID30384 Error while evaluating function convert'. Originally ExpressionEvaluationException 'TEIID10060 The string representation '2
015-03-29 02:20:09' of a Timestamp value is not valid.' StringToTimestampTransform.java:67. Enable more detailed logging to see the entire stacktrace.
{code}



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