[CALCITE-2848] Simplifying a case statement's first branch should ignore its safety

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.19.0
• Labels: pull-request-available
• Assignee: Zoltan Haindrich
• Reporter: Zoltan Haindrich
• Created: 14/Feb/19 23:36
• Updated: 25/Mar/19 00:11
• Resolved: 24/Feb/19 14:36

Description

Example: a very simple CASE which is not get rewritten because the first condition branch contains an unknown UDF

CASE
 WHEN to_date('2001-11-11') = '2000' THEN true
 ELSE false
END

This expression right now retained as is; because the "to_date" was an unknown UDF; but since the first branch of a CASE is always evaluated and that could unlock the rewrite of this case to it's boolean form.

Issue Links

• links to: GitHub Pull Request #1046