[jira] [Created] (CALCITE-4155) Simplify in expression of discreet values

["Liya Fan (Jira)" <ji...@apache.org>]

Liya Fan created CALCITE-4155:
---------------------------------

             Summary: Simplify in expression of discreet values
                 Key: CALCITE-4155
                 URL: https://issues.apache.org/jira/browse/CALCITE-4155
             Project: Calcite
          Issue Type: New Feature
          Components: core
            Reporter: Liya Fan
            Assignee: Liya Fan


For example, given expressions like

{{a in (1, 2, 3, 4, 5)}}

or

{{a = 1 or a = 2 or a = 3 or a = 4 or a = 5}},

we can simplify it to

{{a >= 1 and a <= 5}}

Such simplification reduces the number of value comparisons from 5 to 2. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)