[jira] [Created] (ASTERIXDB-2778) Incorrect result order with GROUP BY ROLLUP

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

Dmitry Lychagin created ASTERIXDB-2778:
------------------------------------------

             Summary: 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
             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)