[ https://issues.apache.org/jira/browse/ASTERIXDB-2348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Till resolved ASTERIXDB-2348. ----------------------------- Resolution: Fixed > Incorrect result with distinct aggregate > ---------------------------------------- > > Key: ASTERIXDB-2348 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-2348 > Project: Apache AsterixDB > Issue Type: Bug > Components: COMP - Compiler > Reporter: Dmitry Lychagin > Assignee: Dmitry Lychagin > Priority: Minor > > Input data: > insert into t1 select value t from [ > \{"c_id":"01","c_b":true, "c_d":900,"c_i":999999}, > \{"c_id":"02","c_b":true, "c_d":800,"c_i":888888}, > \{"c_id":"03","c_b":true, "c_d":700,"c_i":777777}, > \{"c_id":"05","c_b":false,"c_d":111,"c_i":111111} > ] t > Query: > select min(distinct c_i) v > from t1 > where c_b > group by c_i, c_d, c_b > order by v > Expected result: > { "v": 777777 } > { "v": 888888 } > { "v": 999999 } > Actual result: > { "v": { } } > { "v": { } } > { "v": { } } > > Note, when 'distinct' is removed then the expected result is returned. > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)