Symptom
Following query statement having "CASE WHEN EXISTS" does not return any result after upgrading IQ from 16.0 SP11.28 to 16.1 SP05.09.
SELECT CASE WHEN EXISTS
(
select 1
from
"TAB01" as "mk"
join "TAB02" as "md" on("mk"."COL01" = "md"."COL01")
join "TAB03" as "ck" on("ck"."COL02" = "mk"."COL02")
join "TAB04" as "cd" on("ck"."COL01" = "cd"."COL01")
join "TAB05" as "sk" on("sk"."COL02" = "mk"."COL02")
join "TAB06" as "sd" on("sk"."COL01" = "sd"."COL01")
where
"mk"."COL02" >= '20240801'
and "mk"."COL02" <= '20240801'
and "md"."COL03" = "cd"."COL03"
and "cd"."COL03" = "sd"."COL03"
and "md"."COL03" = '9999-12-01'
and "md"."COL04" > -1
and "cd"."COL04" > -1
and "sd"."COL04" > -1
) THEN 'y' else 'n' END
Read more...
Environment
- SAP IQ 16.1 SP05.09
Product
Keywords
KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Bug Filed
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.