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

[RH Bugzilla Integration (JIRA)]

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

RH Bugzilla Integration updated TEIID-4656:
-------------------------------------------
    Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1404859
        Bugzilla Update: Perform


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