[CALCITE-4637] is not null in case is lost

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Bug
• Affects Version/s: 1.21.0
• Component/s: core
• Assignee: Unassigned
• Reporter: bocaiding
• Created: 04/Jun/21 10:13
• Updated: 18/Jun/21 09:00
• Resolved: 07/Jun/21 07:33

Description

I found a query like below will lost condition.

select case when a > 9 and b is not null and b < 8 then c end from tbl

the "b is not null" get lost.

 

i.e. add such a test case in RexProgramTest will fail:

checkSimplifyUnchanged(
case_(and(gt(vIntNotNull(0), literal(9)), lt(vInt(1), literal(8)), isNotNull(vInt(1))),
literal(7), literal(6)));