You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Evgeny Stanilovsky (Jira)" <ji...@apache.org> on 2021/09/20 11:29:00 UTC

[jira] [Created] (IGNITE-15539) Calcite. Unexpected resultset from aggregate query.

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)