Cannot getting empty result in case

mgvertica

I cannot get empty result in case and it returns NULL result:

SELECT CASE WHEN ('test' IS NULL) THEN (SELECT 'null_result') ELSE (SELECT 'empty_result' WHERE 1<>1) END;

mgvertica

I found the answer:
https://stackoverflow.com/questions/56372462/how-to-get-empty-result-set-with-a-case-statement

Jim_Knicely

The query gives correct results:

dbadmin=> SELECT CASE WHEN ('test' IS NULL) THEN (SELECT 'null_result') ELSE (SELECT 'empty_result' WHERE 1<>1) END;
 case
------

(1 row)

dbadmin=> SELECT CASE WHEN ('test' IS NULL) THEN (SELECT 'null_result') ELSE (SELECT 'empty_result' WHERE 1=1) END;
     case
--------------
 empty_result
(1 row)