By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SET @v = 'a';
SELECT 'yes'
FROM dual
WHERE 1 != 2
AND (CASE @v WHEN 'a' THEN 1 = 1
WHEN 'b' THEN 1 = 2
ELSE 1
END)
| yes |
|---|
| yes |
SET @v = 'b';
SELECT 'yes'
FROM dual
WHERE 1 != 2
AND (CASE @v WHEN 'a' THEN 1 = 1
WHEN 'b' THEN 1 = 2
ELSE 1
END)
| yes |
|---|
SET @v = 'c';
SELECT 'yes'
FROM dual
WHERE 1 != 2
AND (CASE @v WHEN 'a' THEN 1 = 1
WHEN 'b' THEN 1 = 2
ELSE 1
END)
| yes |
|---|
| yes |