Symptom
- A LEFT OUTER JOIN on ISNULL() may return an incorrect result set. For example, "select * from A left outer join B on IsNull(A.b,9999) = B.b;"
- To be more generic any query having a LEFT OUTER JOIN with all the Join condition as invariant predicate (either they are invariant or become invariant because of some simplification by the Optimizer) might return a wrong result.
Read more...
Environment
SAP Sybase IQ 15.4
Product
SAP Sybase IQ 15.4
Keywords
OUTER JOIN , incorrect result , simplification , , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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.