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

[Steve Hawkins (JIRA)]

    [ https://jira.jboss.org/browse/TEIID-1193?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12543820#action_12543820 ] 

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