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

Posted to dev@calcite.apache.org by "duan xiong (Jira)" <ji...@apache.org> on 2021/10/09 08:45:00 UTC

[jira] [Created] (CALCITE-4843) optimize ALL,SOME sub-query list when op is the <, <=,> or >=

duan xiong created CALCITE-4843:
-----------------------------------

             Summary: optimize ALL,SOME sub-query list when op is the <, <=,> or >=
                 Key: CALCITE-4843
                 URL: https://issues.apache.org/jira/browse/CALCITE-4843
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.27.0
            Reporter: duan xiong
            Assignee: duan xiong


some example:
{code:java}
sal > all (values 1, 2, 3, 4, 5, 6, 7, null) can be optimized to sal>all(values 7, null)
sal > some(values 1, 2, 3, 4, 5, 6, 7, null) can be optimized to sal>some(values 1, null){code}



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