[teiid-issues] [JBoss JIRA] (TEIID-5311) Sybase implicitly Convertion of String value 'yyyy-MM-dd HH:mm' into a Date value Causes mismatches in JDV Date comparison

[Anu Saji (JIRA)]

Anu Saji created TEIID-5311:
-------------------------------

             Summary: Sybase implicitly Convertion of String value 'yyyy-MM-dd HH:mm' into a Date value Causes mismatches in JDV Date comparison
                 Key: TEIID-5311
                 URL: https://issues.jboss.org/browse/TEIID-5311
             Project: Teiid
          Issue Type: Enhancement
          Components: JDBC Connector, Query Engine
            Reporter: Anu Saji
            Assignee: Steven Hawkins
            Priority: Minor
             Fix For: 10.x


Sybase implicitly converts a String value 'yyyy-MM-dd HH:mm' into a Date value.
This format is not standard and this conversion is specific to Sybase.

As JDBC/Java standard, JDV implicitly converts
'yyyy-MM-dd HH:mm:ss' into a Timestamp value
'yyyy-MM-dd' into a Date value
So JDV does not considered 'yyyy-MM-dd HH:mm' as a Date value and does not proceed to any implicit conversion. 'yyyy-MM-dd HH:mm'  remains like a String value which partially matches with Date comparison  

Constraint
We cannot modify the incoming query





--
This message was sent by Atlassian JIRA
(v7.5.0#75005)