[FLINK-19811] FlinkRexUtil#simplify should simplify search in conjunctions

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.12.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: godfrey he
• Reporter: Caizhi Weng
• Created: 26/Oct/20 13:14
• Updated: 30/May/23 07:53
• Resolved: 07/Nov/20 16:04

Description

The new version of Calcite introduces the SEARCH rex call to express range conditions. However SEARCH}}s in conjunctions are currently not simplified. For example, {{AND(=($2, 2020), SEARCH($2, Sarg[2020, 2021])) is not simplified while it should be simplified to =($2, 2020).

This issue is caused by CALCITE-4364. We could currently extend the RexSimplify class to temporarily cover this issue.

Issue Links

• is caused by: CALCITE-4364 Simplify "a IN (1, 2) AND a = 1" to "a = 1"
• links to: GitHub Pull Request #13793
• links to: GitHub Pull Request #13931