SAP Knowledge Base Article - Preview

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


  • 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.



SAP Sybase IQ 15.4


SAP Sybase IQ 15.4


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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.