[ASTERIXDB-2696] Incorrect result with nested subplans

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.4.1
• Fix Version/s: 0.9.7
• Component/s: COMP - Compiler
• Assignee: Dmitry Lychagin
• Reporter: Dmitry Lychagin
• Created: 07/Feb/20 23:53
• Updated: 05/Jan/22 22:37
• Resolved: 05/Jan/22 22:37

Description

The following query returns wrong result:

from [
   { "a": 1, "b": [ 10, 20, 30] },
   { "a": 1, "b": [ 40, 50, 60] },
   { "a": 1, "b": [ 70, 80, 90] },
   { "a": 2, "b": [ 100, 200, 300] },
   { "a": 2, "b": [ 400, 500, 600] },
   { "a": 2, "b": [ 700, 800, 900] }
] t
group by a
select a, sum( case when some x in b satisfies x >= 50 then 1 else 0 end) as s;

Current result:

{ "a": 1, "s": 1 }
{ "a": 2, "s": 1 }

Correct result should be:

{ "a": 1, "s": 2 }
{ "a": 2, "s": 3 }