Symptom
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');
Read more...
Environment
SAP IQ16 SP08.x less than SP8.7
Product
SAP IQ 16.0
Keywords
incorrect result, coalesce, isnull, case expression, sybase, IQ, problem, incorrect, wrong, result, value , KBA , BC-SYB-IQ , Sybase IQ , Problem
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.