[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)]

    [ https://issues.jboss.org/browse/TEIID-4428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13289225#comment-13289225 ] 

dalex dalex commented on TEIID-4428:
------------------------------------

[~shawkins] I'm very sorry that I didn't notice duplicate of the issue, thx.

> 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)