Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
Simplify expressions like:
a = 1 AND (a = 1 OR a = 2)
to
a = 1
Conditions to apply will be:
- in an AND condition there exists a comparison(c) and an OR (o)
- o and c only reference 1 variable
See HIVE-19097 for more info.
Attachments
Issue Links
- causes
-
CALCITE-3192 Simplification may weaken OR conditions containing inequalities
- Closed
- relates to
-
CALCITE-2314 Verify RexNode transformations by evaluating before and after expressions against sample values
- Closed
-
HIVE-19097 related equals and in operators may cause inaccurate stats estimations
- Closed
-
CALCITE-2326 Generalize p(x) IS TRUE/FALSE/UNKNOWN handling in RexSimplify
- Open
-
CALCITE-2257 Combination of predicates can be proved to be always true
- Closed
- links to