]
Johnathon Lee updated TEIID-4656:
---------------------------------
Fix Version/s: 8.7.11.6_2
(was: 8.7.10.6_2)
parseTimestamp issue with Oracle
--------------------------------
Key: TEIID-4656
URL:
https://issues.jboss.org/browse/TEIID-4656
Project: Teiid
Issue Type: Bug
Components: JDBC Connector, Query Engine
Affects Versions: 8.12
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.2, 8.12.9.6_3, 8.7.11.6_2
parseTimestamp is pushed as to_timestamp. However TO_TIMESTAMP is not generally valid
unless the format string covers the entire string input value otherwise there is an
exception about the picture ending.
This means in general that we cannot pushdown the parseDate/Time/Timestamp operations to
oracle as that is behavioral different with the java format routines, which will process
just to the end of the format string.