[teiid-issues] [JBoss JIRA] Closed: (TEIID-923) Oracle queries with a TimeStamp in the WHERE clause are failing if multiple TimeStamps are used in "AND", "OR', and "IN" situations

[Steve Hawkins (JIRA)]

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

Steve Hawkins closed TEIID-923.
-------------------------------



> Oracle queries with a TimeStamp in the WHERE clause are failing if multiple TimeStamps are used in "AND", "OR', and "IN" situations
> -----------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-923
>                 URL: https://jira.jboss.org/browse/TEIID-923
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 7.0
>         Environment: CTC Query Suite running Teiid 7.0 with ojdbc6 driver
>            Reporter: Warren Gibson
>            Assignee: Steven Hawkins
>             Fix For: 7.0
>
>         Attachments: QT_ora10ds.vdb
>
>
> The following queries are failing in CTC with an ORCL errors "invalid characters" or "missing right parenthesis".  The ojdbc6 driver is being used.  Oracle10 VDB attached.
> SELECT BQT1.SmallA.IntKey FROM BQT1.SmallA WHERE BQT1.SmallA.TimeStampValue IN (convert('2000-01-01 00:00:12.0', timestamp), convert('2000-01-01 00:00:45.0', timestamp)) ORDER BY IntKey
> SELECT BQT1.SmallA.IntKey FROM BQT1.SmallA WHERE BQT1.SmallA.TimestampValue > '2000-01-01 00:00:25.0' AND BQT1.SmallA.TimeStampValue < '2000-01-01 00:00:30.0' ORDER BY IntKey
> SELECT IntKey, TimestampValue FROM BQT1.SmallA WHERE TimestampValue > '2000-01-01 00:00:47.0' OR TimestampValue < '2000-01-01 00:00:02.0' ORDER BY IntKey

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira