2076282 - [SAP IQ] Query with coalesce, isnull, or case expressions could generate in correct result in Iq16 SP08.x.

IQ is getting wrong results set even though there are data to meet the conditions.

[Query]

SELECT ISNULL(A.YMD001,'1111-01-01') as a
, ISNULL(A.YMD002,'1111-01-01') as b
, (CASE WHEN ISNULL(A.YMD001,'1111-01-01') > ISNULL(A.YMD002,'1111-01-01')
THEN A.YMD001
ELSE A.YMD002
END) AS YMD_RLT
...
WHERE A.KEY_COL001 = B.KEY_COL001
...
AND YMD_RLT < DATE('20141130');

SAP IQ16 SP08.x less than SP8.7

incorrect result, coalesce, isnull, case expression, sybase, IQ, problem, incorrect, wrong, result, value , KBA , BC-SYB-IQ , Sybase IQ , Problem