SAP Knowledge Base Article - Preview

1910862 - IQ 15.4 - LEFT OUTER JOIN on ISNULL() may produce an incorrect result

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.