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

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. 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