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

[Juraj Duráni (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4656?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13342133#comment-13342133 ] 

Juraj Duráni commented on TEIID-4656:
-------------------------------------

I see. However, I still consider this to be an issue. I will file a new one.

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