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

OUTER JOIN , incorrect result , simplification , , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed