Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.4.2
-
None
-
ubuntu 20.04
Description
select nullif(SPACE(5), case when false then ('TEST') else ('l' || 'o') end) as c1; |
+-------+ |
| c1 |
|
+-------+ |
| |
|
+-------+ |
1 row in set, 2 warnings (0.00 sec) |
|
|
|
select nullif(SPACE(5), ('l' || 'o')) as c1; |
+------+ |
| c1 |
|
+------+ |
| NULL | |
+------+ |
1 row in set, 3 warnings (0.00 sec) |
|
|
The condition for CASE WHEN is FALSE, so this clause should return the result of (l || o). This statement should return the same value as SELECT NULLIF(SPACE(5), ('l' || 'o')) AS c1;, but the actual result is not the same.