Symptom
After upgrade from IQ15.4 to 16.1, Rows containing (NULL) values are not evaluated when evaluating right table column values in a subquery within a LEFT JOIN.
ex:
Select col1, col2, col_c, col_d from j01
left join (select j02.col1 as col_c, if(j02.col2 IS NULL) then 'ABC' else 'TTT' endif as col_d from j02) j02a
on j01.col1 = j02a.col_c ;
col1 col2 col_c col_d
---------------------------
1 abcd (NULL) (NULL)
2 abcd 2 TTT
But SAP IQ 15.4 returned below output -- 'ABC' is set to col_d in the first row.
col1 col2 col_c col_d
---------------------------
1 abcd (NULL) ABC
2 abcd 2 TTT
Read more...
Environment
- SAP IQ 16.x
- SAP IQ 15.4
Product
Keywords
"15.2", "15.3", "15.4", "LEFT JOIN", "derived table", "incorrect results", "Sort Merge", "HASH", "subquery", "NULL" , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview