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

[Johnathon Lee (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4656?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Johnathon Lee updated TEIID-4656:
---------------------------------
    Fix Version/s: 8.12.9.6_3


> 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: 8.7.10.6_2, 9.2, 8.12.9.6_3
>
>
> 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)