[JBoss JIRA] Created: (TEIID-923) Oracle queries with a TimeStamp in the WHERE clause are failing if multiple TimeStamps are used in "AND", "OR', and "IN" situations
12:38 p.m.
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/jira/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
The following queries are failing in CTC with an ORCL errors "invalid
characters" or "missing right parenthesis". The ojdbc6 driver is being
used.
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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:42 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-923) Oracle queries with a TimeStamp in the WHERE clause are failing if multiple TimeStamps are used in "AND", "OR', and "IN" situations
[
https://jira.jboss.org/jira/browse/TEIID-923?page=com.atlassian.jira.plug...
]
Warren Gibson updated TEIID-923:
--------------------------------
Attachment: QT_ora10ds.vdb
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/jira/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
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.
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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:42 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-923) Oracle queries with a TimeStamp in the WHERE clause are failing if multiple TimeStamps are used in "AND", "OR', and "IN" situations
[
https://jira.jboss.org/jira/browse/TEIID-923?page=com.atlassian.jira.plug...
]
Warren Gibson updated TEIID-923:
--------------------------------
Description:
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
was:
The following queries are failing in CTC with an ORCL errors "invalid
characters" or "missing right parenthesis". The ojdbc6 driver is being
used.
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
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/jira/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
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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-923) Oracle queries with a TimeStamp in the WHERE clause are failing if multiple TimeStamps are used in "AND", "OR', and "IN" situations
[
https://jira.jboss.org/jira/browse/TEIID-923?page=com.atlassian.jira.plug...
]
Steven Hawkins updated TEIID-923:
---------------------------------
Fix Version/s: 7.0
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/jira/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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:24 p.m.
New subject: [JBoss JIRA] Resolved: (TEIID-923) Oracle queries with a TimeStamp in the WHERE clause are failing if multiple TimeStamps are used in "AND", "OR', and "IN" situations
[
https://jira.jboss.org/jira/browse/TEIID-923?page=com.atlassian.jira.plug...
]
Steven Hawkins resolved TEIID-923.
----------------------------------
Resolution: Done
Changed our escaping logic to use a space between the type identifier and string literal.
For whatever reason Oracle could only handle one escape sequence without a space.
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/jira/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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:09 a.m.
New subject: [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
[
https://jira.jboss.org/browse/TEIID-923?page=com.atlassian.jira.plugin.sy...
]
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
5122
days inactive
5292
days old
5 comments
3 participants
participants (3)
-
Steve Hawkins (JIRA) -
Steven Hawkins (JIRA)
-
Warren Gibson (JIRA)