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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.27.0
• Component/s: core
• Assignee: xiong duan
• Reporter: xiong duan
• Created: 09/Oct/21 08:44
• Updated: 14/Oct/21 22:52

Description

some example:

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)

Issue Links

• relates to: CALCITE-4758 When SOME sub-query is SqlNodeList, Calcite returns wrong result