[jira] [Created] (CALCITE-7046) 'CASE a WHEN null THEN 1 ELSE b END' should return 1 when a is null

[xiong duan (Jira)]

xiong duan created CALCITE-7046:
-----------------------------------

             Summary: 'CASE a WHEN null THEN 1 ELSE b END' should return 1 when 
a is null
                 Key: CALCITE-7046
                 URL: https://issues.apache.org/jira/browse/CALCITE-7046
             Project: Calcite
          Issue Type: Bug
            Reporter: xiong duan


The SQL in dummy.iq:
{code:java}
select *,case deptno when null then 1 else deptno + 2 end from emp where 
ename='Wilma';
ENAME, DEPTNO, GENDER, EXPR$3
Wilma, null, F, null{code}
The column EXPR$3 value should be 1



--
This message was sent by Atlassian Jira
(v8.20.10#820010)