-
Type:
Improvement
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.26.0
-
Component/s: None
-
Labels:
The following filters for a number are always true
x > 0 or x <= 0 or x is null x < 0 or x >= 0 or x is null x < 1 or x > 0 or x is null
where the 1/0 can be replaced by any number where the first is greater than the second
The following filter for a varchar is always true:
x LIKE '%' OR x is null
It would be nice if RexSimplify.simplifyOrTerms handled these cases.
- causes
-
CALCITE-4258 SqlToRelConverter: SELECT 1 IS [NOT] DISTINCT FROM NULL fails with AssertionError
-
- Closed
-
- relates to
-
CALCITE-4190 OR simplification incorrectly loses term
-
- Closed
-
-
CALCITE-4155 Simplify IN expression of discrete values
-
- Open
-
- links to