[ https://issues.apache.org/jira/browse/ASTERIXDB-2778?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17196451#comment-17196451 ]
ASF subversion and git services commented on ASTERIXDB-2778: ------------------------------------------------------------ Commit 6a55b01a2dabf798244362ffe8788fbadeff7e5e in asterixdb's branch refs/heads/master from Dmitry Lychagin [ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=6a55b01 ] [ASTERIXDB-2778][COMP] Incorrect result order with grouping sets - user model changes: no - storage format changes: no - interface changes: no Details: - Fix incorrect order produced by ORDER BY in the presence of GROUP BY with GROUPING SETS - SqlppExpressionToPlanTranslator should include GroupBy's decor variables when processing SELECT * - UnionAll runtime should not emit next frame if it's in the failed state Change-Id: If9ccdb70b0905ae34a46e1cc112a424eb00406b8 Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/7884 Integration-Tests: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Tested-by: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Reviewed-by: Dmitry Lychagin <dmitry.lycha...@couchbase.com> Reviewed-by: Ali Alsuliman <ali.al.solai...@gmail.com> > Incorrect result order with GROUP BY ROLLUP > ------------------------------------------- > > Key: ASTERIXDB-2778 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-2778 > Project: Apache AsterixDB > Issue Type: Bug > Components: COMP - Compiler > Affects Versions: 0.9.5 > Reporter: Dmitry Lychagin > Assignee: Dmitry Lychagin > Priority: Major > Fix For: 0.9.6 > > > Incorrect result order for the following query: > > {noformat} > SELECT > ROUND(SUM(i.qty * i.selling_price)) total, > p.category, p.name > FROM ShopALot.Orders o > UNNEST o.items i > JOIN ShopALot.Products p ON i.product_id = p.product_id > GROUP BY ROLLUP(p.category, p.name) > ORDER BY total desc, p.category, p.name > LIMIT 20; > {noformat} > The result is not ordered by 'total' field. -- This message was sent by Atlassian Jira (v8.3.4#803005)