[teiid-issues] [JBoss JIRA] (TEIID-4656) parseTimestamp issue with Oracle

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-4656:
-------------------------------------

             Summary: 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


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.  



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)