[
https://issues.apache.org/jira/browse/IGNITE-25578?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-25578:
--------------------------------------
Summary: Sql. Add tests for GROUP BY ROLLUP / CUBE (was: Sql. Add tests
for GROUP BY ROLLUP)
> Sql. Add tests for GROUP BY ROLLUP / CUBE
> -----------------------------------------
>
> Key: IGNITE-25578
> URL: https://issues.apache.org/jira/browse/IGNITE-25578
> Project: Ignite
> Issue Type: Improvement
> Components: sql ai3
> Reporter: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
>
> 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)
