Dmitry Lychagin created ASTERIXDB-2612:
------------------------------------------

             Summary: Incorrect result with two-step aggregate function
                 Key: ASTERIXDB-2612
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2612
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: COMP - Compiler
            Reporter: Dmitry Lychagin
            Assignee: Dmitry Lychagin


On a system with 2 nodes and 2 I/O devices on each node the following query 
returns wrong result because of the two-step aggregate rewriting:

{noformat}
select m, array_count((from g select value g.t.unique1 limit 3)) cnt
from onektup t
group by unique2 % 2 as m group as g
order by m
{noformat}

Expected:
{noformat}
{ "m": 0, "cnt": 3 }
{ "m": 1, "cnt": 3 }
{noformat}

Actual result.
{ "m": 0, "cnt": 12 }
{ "m": 1, "cnt": 12 }

Dataset: data/wisc/onektup.adm



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)

Reply via email to