[CALCITE-6418] Expression with ALL aggregate return unexpected result.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.37.0
• Component/s: core
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 23/May/24 12:39
• Updated: 28/Oct/24 18:09

Description

I expect that:

SELECT i=ALL(SELECT i FROM (values(1), (null)) integers(i) WHERE i=i1.i OR i IS NULL) FROM (values(1), (2)) i1(i) ORDER BY i;

expect that will return:

null
null

or

false
false

(standard defines only true|false) as a return result for EVERY aggregate

instead:

true
null

was observed.

Issue Links

• causes: IGNITE-23555 Calcite. Incorrect results with operator ALL.
• is related to: CALCITE-1845 Quantified comparison predicates (SOME, ANY, ALL)
• is related to: CALCITE-3815 Add missing SQL standard aggregate functions: EVERY, SOME, INTERSECTION