Ooooh, you should like this puzzler, folks! What's the output of
SELECT
(SELECT
CASE
WHEN FALSE
THEN COUNT(1)
ELSE 42
END
FROM table
WHERE FALSE
) AS test_result;
SELECT
(SELECT
CASE
WHEN FALSE
THEN COUNT(1)
ELSE 42
END
FROM table
WHERE FALSE
) AS test_result;
Comments
Now, if you want a *real* puzzler, explain this one:
SELECT (SELECT COUNT(a))
FROM (VALUES (1)) AS t (a)
WHERE FALSE
SELECT (SELECT COUNT(*))
FROM (VALUES (1)) AS t (a)
WHERE FALSE