You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Remus Rusanu (JIRA)" <ji...@apache.org> on 2017/05/16 15:22:04 UTC

[jira] [Created] (CALCITE-1794) Simplify AND numeric comparisons when overlapping

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)