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)
