[ https://jira.jboss.org/browse/TEIID-1193?page=com.atlassian.jira.plugin.s... ] Warren Gibson updated TEIID-1193: --------------------------------- Attachment: Expr6_S-1003-Teiid-log QT_db2v97ds.vdb QT_db2v97ds-ds.xml -- 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

[ https://jira.jboss.org/browse/TEIID-1193?page=com.atlassian.jira.plugin.s... ] Warren Gibson updated TEIID-1193: --------------------------------- Description: 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 was: 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

[ https://jira.jboss.org/browse/TEIID-1193?page=com.atlassian.jira.plugin.s... ] Steve Hawkins resolved TEIID-1193. ---------------------------------- Resolution: Rejected This will not happen with the db2 translator. -- 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