IQ is getting wrong results set even though there are data to meet the conditions.
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')
END) AS YMD_RLT
WHERE A.KEY_COL001 = B.KEY_COL001
AND YMD_RLT < DATE('20141130');
SAP IQ16 SP08.x less than SP8.7
SAP IQ 16.0
incorrect result, coalesce, isnull, case expression, sybase, IQ, problem, incorrect, wrong, result, value , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis 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.