[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1193) DB2 9.1 & 9.7 - VQT query SELECT * FROM VQT.Expr6 AS X - unexpected QUERY results

Tue Aug 10 06:04:49 EDT 2010

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

Steve Hawkins resolved TEIID-1193.
----------------------------------

    Resolution: Rejected

This will not happen with the db2 translator.

> 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_Queries_Expr6_S-1003.xml, 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 and the expected results file.
> 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