[ https://issues.apache.org/jira/browse/ASTERIXDB-2778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dmitry Lychagin resolved ASTERIXDB-2778. ---------------------------------------- Resolution: Fixed > 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)