[teiid-issues] [JBoss JIRA] Updated: (TEIID-1193) DB2 9.1 & 9.7 - VQT query SELECT * FROM VQT.Expr6 AS X - unexpected QUERY results
Warren Gibson (JIRA)
jira-events at lists.jboss.org
Mon Aug 9 15:06:49 EDT 2010
[ https://jira.jboss.org/browse/TEIID-1193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Warren Gibson updated TEIID-1193:
---------------------------------
Attachment: Expr6_S-1003-Teiid-log
QT_db2v97ds.vdb
QT_db2v97ds-ds.xml
> DB2 9.1 & 9.7 - VQT query SELECT * FROM VQT.Expr6 AS X - unexpected QUERY results
> ----------------------------------------------------------------------------------
>
> Key: TEIID-1193
> URL: https://jira.jboss.org/browse/TEIID-1193
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 7.1
> Environment: Teiid-7.1.0.CR2
> Reporter: Warren Gibson
> Assignee: Steve Hawkins
> Attachments: Expr6_S-1003-Teiid-log, QT_db2v97ds-ds.xml, QT_db2v97ds.vdb
>
>
> The following VQT query is producing CTC unexpected results in DB2 9.1 and 9.7. VDB is attached along with a DEBUG log file from CTC execution.
> SELECT * FROM VQT.Expr6 AS X
> When I submit the query plan source query straight to the source in Squirrel it also fails.
> Source query from plan: SELECT SMALLA.STRINGNUM, NULL FROM SMALLA
> Squirrel Error: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=NULL, DRIVER=4.0.100
> SQLState: 42703
> ErrorCode: -206
> Error: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-206;42703;NULL, DRIVER=4.0.100
> SQLState: 56098
> ErrorCode: -727
--
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
More information about the teiid-issues
mailing list