Caizhi Weng created FLINK-19811:
-----------------------------------
Summary: FlinkRexUtil#simplify should simplify search in conjunctions
Key: FLINK-19811
URL:
https://issues.apache.org/jira/browse/FLINK-19811 Project: Flink
Issue Type: Improvement
Components: Table SQL / Planner
Reporter: Caizhi Weng
Fix For: 1.12.0
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)}}.
We can expand the {{SEARCH}} rex calls in {{FlinkRexUtil#simplify}} to achieve this. {{RexSimplify#simplify}} in Calcite will do the rest of the work.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
Locked
