[JBoss JIRA] Created: (TEIID-1181) Teiid Pushdown queries producing unexpected results (Sybase 12.5)
1:58 a.m.
Teiid Pushdown queries producing unexpected results (Sybase 12.5)
-----------------------------------------------------------------
Key: TEIID-1181
URL: https://jira.jboss.org/browse/TEIID-1181
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: Teiid 7.1
Reporter: Warren Gibson
Assignee: Steve Hawkins
The attached sampling of 43 queries submitted against Sybase 12.5 are producing unexpected
results in Teiid pushdown query testing but are producing expected results when submitted
straight to the source through Squirrel. Column A of the attached spreadsheet contains
the query and my comments. Columns B & C contains info from the query testing run. I
am attaching the VDB, ds, and driver. If I can provide any additional information please
let me know.
--
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
2:02 a.m.
New subject: [JBoss JIRA] Updated: (TEIID-1181) Teiid Pushdown queries producing unexpected results (Sybase 12.5)
[
https://jira.jboss.org/browse/TEIID-1181?page=com.atlassian.jira.plugin.s...
]
Warren Gibson updated TEIID-1181:
---------------------------------
Attachment: sybase125_queries.ods
QT_Syb125_Push.vdb
QT_Sybase_Push-ds.xml
Teiid Pushdown queries producing unexpected results (Sybase 12.5)
-----------------------------------------------------------------
Key: TEIID-1181
URL: https://jira.jboss.org/browse/TEIID-1181
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: Teiid 7.1
Reporter: Warren Gibson
Assignee: Steve Hawkins
Attachments: QT_Syb125_Push.vdb, QT_Sybase_Push-ds.xml, sybase125_queries.ods
The attached sampling of 43 queries submitted against Sybase 12.5 are producing
unexpected results in Teiid pushdown query testing but are producing expected results when
submitted straight to the source through Squirrel. Column A of the attached spreadsheet
contains the query and my comments. Columns B & C contains info from the query
testing run. I am attaching the VDB, ds, and driver. If I can provide any additional
information please let me know.
--
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
2:04 a.m.
New subject: [JBoss JIRA] Updated: (TEIID-1181) Teiid Pushdown queries producing unexpected results (Sybase 12.5)
[
https://jira.jboss.org/browse/TEIID-1181?page=com.atlassian.jira.plugin.s...
]
Warren Gibson updated TEIID-1181:
---------------------------------
Attachment: jconn3.jar
Teiid Pushdown queries producing unexpected results (Sybase 12.5)
-----------------------------------------------------------------
Key: TEIID-1181
URL: https://jira.jboss.org/browse/TEIID-1181
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: Teiid 7.1
Reporter: Warren Gibson
Assignee: Steve Hawkins
Attachments: jconn3.jar, QT_Syb125_Push.vdb, QT_Sybase_Push-ds.xml,
sybase125_queries.ods
The attached sampling of 43 queries submitted against Sybase 12.5 are producing
unexpected results in Teiid pushdown query testing but are producing expected results when
submitted straight to the source through Squirrel. Column A of the attached spreadsheet
contains the query and my comments. Columns B & C contains info from the query
testing run. I am attaching the VDB, ds, and driver. If I can provide any additional
information please let me know.
--
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
2:40 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-1181) Teiid Pushdown queries producing unexpected results (Sybase 12.5)
[
https://jira.jboss.org/browse/TEIID-1181?page=com.atlassian.jira.plugin.s...
]
Steve Hawkins commented on TEIID-1181:
--------------------------------------
The error indicating 123 is not a valid format should be a KI for Sybase older than
version 15, for which we will not currently support timestamp to string conversion.
The JZ0TE errors are happening in the Sybase driver, which doesn't seem to support a
call to getByte() - are you using the EAP supported driver?
The errors about bit being a non-null type can be easily fixed.
Teiid Pushdown queries producing unexpected results (Sybase 12.5)
-----------------------------------------------------------------
Key: TEIID-1181
URL: https://jira.jboss.org/browse/TEIID-1181
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: Teiid 7.1
Reporter: Warren Gibson
Assignee: Steve Hawkins
Attachments: jconn3.jar, QT_Syb125_Push.vdb, QT_Sybase_Push-ds.xml,
sybase125_queries.ods
The attached sampling of 43 queries submitted against Sybase 12.5 are producing
unexpected results in Teiid pushdown query testing but are producing expected results when
submitted straight to the source through Squirrel. Column A of the attached spreadsheet
contains the query and my comments. Columns B & C contains info from the query
testing run. I am attaching the VDB, ds, and driver. If I can provide any additional
information please let me know.
--
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
3:16 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1181) Teiid Pushdown queries producing unexpected results (Sybase 12.5)
[
https://jira.jboss.org/browse/TEIID-1181?page=com.atlassian.jira.plugin.s...
]
Steve Hawkins commented on TEIID-1181:
--------------------------------------
Unless the JZ0TE happens with Sybase 15 as well, I'd be inclined to mark this resolved
with the fix to the "not null" bit error.
Teiid Pushdown queries producing unexpected results (Sybase 12.5)
-----------------------------------------------------------------
Key: TEIID-1181
URL: https://jira.jboss.org/browse/TEIID-1181
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: Teiid 7.1
Reporter: Warren Gibson
Assignee: Steve Hawkins
Attachments: QT_Syb125_Push.vdb, sybase125_queries.ods
The attached sampling of 43 queries submitted against Sybase 12.5 are producing
unexpected results in Teiid pushdown query testing but are producing expected results when
submitted straight to the source through Squirrel. Column A of the attached spreadsheet
contains the query and my comments. Columns B & C contains info from the query
testing run. I am attaching the VDB, ds, and driver. If I can provide any additional
information please let me know.
--
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
3:16 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-1181) Teiid Pushdown queries producing unexpected results (Sybase 12.5)
[
https://jira.jboss.org/browse/TEIID-1181?page=com.atlassian.jira.plugin.s...
]
Steve Hawkins updated TEIID-1181:
---------------------------------
Attachment: (was: QT_Sybase_Push-ds.xml)
Teiid Pushdown queries producing unexpected results (Sybase 12.5)
-----------------------------------------------------------------
Key: TEIID-1181
URL: https://jira.jboss.org/browse/TEIID-1181
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: Teiid 7.1
Reporter: Warren Gibson
Assignee: Steve Hawkins
Attachments: QT_Syb125_Push.vdb, sybase125_queries.ods
The attached sampling of 43 queries submitted against Sybase 12.5 are producing
unexpected results in Teiid pushdown query testing but are producing expected results when
submitted straight to the source through Squirrel. Column A of the attached spreadsheet
contains the query and my comments. Columns B & C contains info from the query
testing run. I am attaching the VDB, ds, and driver. If I can provide any additional
information please let me know.
--
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
3:16 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-1181) Teiid Pushdown queries producing unexpected results (Sybase 12.5)
[
https://jira.jboss.org/browse/TEIID-1181?page=com.atlassian.jira.plugin.s...
]
Steve Hawkins updated TEIID-1181:
---------------------------------
Attachment: (was: jconn3.jar)
Teiid Pushdown queries producing unexpected results (Sybase 12.5)
-----------------------------------------------------------------
Key: TEIID-1181
URL: https://jira.jboss.org/browse/TEIID-1181
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: Teiid 7.1
Reporter: Warren Gibson
Assignee: Steve Hawkins
Attachments: QT_Syb125_Push.vdb, sybase125_queries.ods
The attached sampling of 43 queries submitted against Sybase 12.5 are producing
unexpected results in Teiid pushdown query testing but are producing expected results when
submitted straight to the source through Squirrel. Column A of the attached spreadsheet
contains the query and my comments. Columns B & C contains info from the query
testing run. I am attaching the VDB, ds, and driver. If I can provide any additional
information please let me know.
--
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
3:45 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1181) Teiid Pushdown queries producing unexpected results (Sybase 12.5)
[
https://jira.jboss.org/browse/TEIID-1181?page=com.atlassian.jira.plugin.s...
]
Warren Gibson commented on TEIID-1181:
--------------------------------------
Sybase 15 is in the process of being set up. Will check the JZOTE error once it is set
up.
Teiid Pushdown queries producing unexpected results (Sybase 12.5)
-----------------------------------------------------------------
Key: TEIID-1181
URL: https://jira.jboss.org/browse/TEIID-1181
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: Teiid 7.1
Reporter: Warren Gibson
Assignee: Steve Hawkins
Attachments: QT_Syb125_Push.vdb, sybase125_queries.ods
The attached sampling of 43 queries submitted against Sybase 12.5 are producing
unexpected results in Teiid pushdown query testing but are producing expected results when
submitted straight to the source through Squirrel. Column A of the attached spreadsheet
contains the query and my comments. Columns B & C contains info from the query
testing run. I am attaching the VDB, ds, and driver. If I can provide any additional
information please let me know.
--
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
7:03 a.m.
New subject: [JBoss JIRA] Resolved: (TEIID-1181) Teiid Pushdown queries producing unexpected results (Sybase 12.5)
[
https://jira.jboss.org/browse/TEIID-1181?page=com.atlassian.jira.plugin.s...
]
Steve Hawkins resolved TEIID-1181.
----------------------------------
Fix Version/s: 7.1
Resolution: Done
Also added a fix that will avoid getByte and preparedstatement setByte by using shorts
instead.
Teiid Pushdown queries producing unexpected results (Sybase 12.5)
-----------------------------------------------------------------
Key: TEIID-1181
URL: https://jira.jboss.org/browse/TEIID-1181
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: Teiid 7.1
Reporter: Warren Gibson
Assignee: Steve Hawkins
Fix For: 7.1
Attachments: QT_Syb125_Push.vdb, sybase125_queries.ods
The attached sampling of 43 queries submitted against Sybase 12.5 are producing
unexpected results in Teiid pushdown query testing but are producing expected results when
submitted straight to the source through Squirrel. Column A of the attached spreadsheet
contains the query and my comments. Columns B & C contains info from the query
testing run. I am attaching the VDB, ds, and driver. If I can provide any additional
information please let me know.
--
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
8:07 p.m.
New subject: [JBoss JIRA] Closed: (TEIID-1181) Teiid Pushdown queries producing unexpected results (Sybase 12.5)
[
https://jira.jboss.org/browse/TEIID-1181?page=com.atlassian.jira.plugin.s...
]
Steve Hawkins closed TEIID-1181.
--------------------------------
Teiid Pushdown queries producing unexpected results (Sybase 12.5)
-----------------------------------------------------------------
Key: TEIID-1181
URL: https://jira.jboss.org/browse/TEIID-1181
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: Teiid 7.1
Reporter: Warren Gibson
Assignee: Steve Hawkins
Fix For: 7.1
Attachments: QT_Syb125_Push.vdb, sybase125_queries.ods
The attached sampling of 43 queries submitted against Sybase 12.5 are producing
unexpected results in Teiid pushdown query testing but are producing expected results when
submitted straight to the source through Squirrel. Column A of the attached spreadsheet
contains the query and my comments. Columns B & C contains info from the query
testing run. I am attaching the VDB, ds, and driver. If I can provide any additional
information please let me know.
--
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
5062
days inactive
5077
days old
9 comments
2 participants
participants (2)
-
Steve Hawkins (JIRA) -
Warren Gibson (JIRA)