Remus Rusanu created CALCITE-1794: ------------------------------------- Summary: Simplify AND numeric comparisons when overlapping Key: CALCITE-1794 URL: https://issues.apache.org/jira/browse/CALCITE-1794 Project: Calcite Issue Type: Improvement Components: core Reporter: Remus Rusanu
Expressions such as {{$1<>1 and $1=2}} can be simplified to {{$1=2}}. Similar {{$1>10 AND $1>20}} can be simplified to {{$1>20}}. Such expressions are produced by the proposed solution for CALCITE-1790 (simplify boolean CASE to complex AND/OR). -- This message was sent by Atlassian JIRA (v6.3.15#6346)