[jira] [Resolved] (ASTERIXDB-2612) Incorrect result with two-step aggregate function

["Dmitry Lychagin (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-2612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dmitry Lychagin resolved ASTERIXDB-2612.
----------------------------------------
    Resolution: Fixed

> 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
>            Priority: Major
>
> 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:
> {noformat}
> { "m": 0, "cnt": 12 }
> { "m": 1, "cnt": 12 }
> {noformat}
> Dataset: data/wisc/onektup.adm



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