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

Mon Aug 9 15:02:49 EDT 2010

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

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