Evgeny Stanilovsky created IGNITE-15539:
-------------------------------------------
Summary: Calcite. Unexpected resultset from aggregate query.
Key: IGNITE-15539
URL: https://issues.apache.org/jira/browse/IGNITE-15539
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Evgeny Stanilovsky
In terms of SqlScriptRunner:
{noformat}
statement ok
CREATE TABLE test (a INTEGER, b INTEGER);
statement ok
INSERT INTO test VALUES (11, 22), (13, 22), (12, 21)
query IR
SELECT test.b, SUM(a) FROM test GROUP BY b ORDER BY COUNT(a) DESC;
----
21 48.000000
22 24.000000
{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
