Runkang He created CALCITE-5780: ----------------------------------- Summary: Always-true OR expressions contains reverse order comparison should be simplified to TRUE Key: CALCITE-5780 URL: https://issues.apache.org/jira/browse/CALCITE-5780 Project: Calcite Issue Type: Improvement Components: core Affects Versions: 1.34.0 Reporter: Runkang He
The following expressions which contains reverse order comparison are always true: {code:sql} 1 > x or 1 <= x or x is null 1 < x or 1 >= x or x is null 1 > x or 0 < x or x is null {code} But currently these expressions are not fully simplified to TRUE, the current simplified results are SEARCH operator. The root cause is that RexSimplify doesn't identify these cases and makes targeted simplification. It would be nice if RexSimplify.simplifyOr handled these cases. -- This message was sent by Atlassian Jira (v8.20.10#820010)