[CALCITE-2240] Extend rule to push predicates into CASE statement

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.17.0
• Assignee: Zoltan Haindrich
• Reporter: Zoltan Haindrich
• Created: 05/Apr/18 15:16
• Updated: 27/Feb/24 22:23
• Resolved: 06/Apr/18 06:50

Description

CaseShuttle may make the optimization but the functions return value doesn't depend on that.

For the following query the =1 is not pushed into the case.

select empno from emp where case when sal > 1000 then empno else sal end = 1

Issue Links

• links to: pr