Evgeny Stanilovsky created IGNITE-25919:
-------------------------------------------
Summary: Sql. Unexpected result with multiple ROLLUP usage
Key: IGNITE-25919
URL: https://issues.apache.org/jira/browse/IGNITE-25919
Project: Ignite
Issue Type: Bug
Components: sql ai3
Affects Versions: 3.0
Reporter: Evgeny Stanilovsky
Query below returns unexpected results:
{noformat}
SELECT a, b, c
FROM (VALUES (1, 2, 3), (4, NULL, 6)) AS t (a, b, c)
GROUP BY ROLLUP(a, b), ROLLUP(a, c)
ORDER BY a, b, c;
{noformat}
It need to be like:
{noformat}
1 2 3
1 2 NULL
....
{noformat}
but obtained:
{noformat}
1 2 3
1 2 3
....
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
