[jira] [Created] (IGNITE-25578) Sql. Add tests for GROUP BY ROLLUP

[Maksim Zhuravkov (Jira)]

Maksim Zhuravkov created IGNITE-25578:
-----------------------------------------

             Summary: Sql. Add tests for GROUP BY ROLLUP
                 Key: IGNITE-25578
                 URL: https://issues.apache.org/jira/browse/IGNITE-25578
             Project: Ignite
          Issue Type: Improvement
          Components: sql ai3
            Reporter: Maksim Zhuravkov


Sql runtime supports GROUP BY ROLLUP but the tests are missing.

Example:

{noformat}
CREATE TABLE sales(customer_id int, product_id int, qty int, price int, id int 
primary key);

INSERT INTO sales VALUES(1, 100, 1, 50, 1);
INSERT INTO sales VALUES(2, 100, 3, 25, 2);
INSERT INTO sales VALUES(1, 120, 1, 10, 3);

SELECT customer_id, sum(qty*price) FROM sales GROUP BY ROLLUP (customer_id, 
product_id) ORDER BY customer_id, product_id;
╔═════════════╤══════════════════╗
║ CUSTOMER_ID │ SUM(QTY * PRICE) ║
╠═════════════╪══════════════════╣
║ 1           │ 50               ║
╟─────────────┼──────────────────╢
║ 1           │ 10               ║
╟─────────────┼──────────────────╢
║ 1           │ 60               ║
╟─────────────┼──────────────────╢
║ 2           │ 75               ║
╟─────────────┼──────────────────╢
║ 2           │ 75               ║
╟─────────────┼──────────────────╢
║ null        │ 135              ║
╚═════════════╧══════════════════╝
{noformat}





--
This message was sent by Atlassian Jira
(v8.20.10#820010)