[ https://issues.apache.org/jira/browse/ASTERIXDB-2348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16423618#comment-16423618 ]
ASF subversion and git services commented on ASTERIXDB-2348: ------------------------------------------------------------ Commit cba9ec76ceaefdfe9a3eafa695f01d739bb74c18 in asterixdb's branch refs/heads/master from [~dlychagin-cb] [ https://git-wip-us.apache.org/repos/asf?p=asterixdb.git;h=cba9ec7 ] [ASTERIXDB-2348][COMP] Incorrect result with distinct aggregate - user model changes: no - storage format changes: no - interface changes: no Details: - Account for micro group by/distinct by operators in EnforceStructuralPropertiesRule Change-Id: I0f440046d6cdb2dc0302c5aa4c01ffacb703ee73 Reviewed-on: https://asterix-gerrit.ics.uci.edu/2544 Tested-by: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Contrib: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Integration-Tests: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Reviewed-by: Till Westmann <ti...@apache.org> > 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)