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}