[teiid-issues] [JBoss JIRA] Commented: (TEIID-1193) DB2 9.1 & 9.7 - VQT query SELECT * FROM VQT.Expr6 AS X - unexpected QUERY results
[
https://jira.jboss.org/browse/TEIID-1193?page=com.atlassian.jira.plugin.s...
]
Steve Hawkins commented on TEIID-1193:
--------------------------------------
This issue is created by the use of a non-db2 translator. The db2 translator correctly
handles null derived columns as cast(null as type). I'm inclined to reject, although
there are some situations where the access node logic could handle this.
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