[ 
https://issues.apache.org/jira/browse/IGNITE-15539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Aleksey Plekhanov updated IGNITE-15539:
---------------------------------------
    Labels: calcite  (was: calcite2-required calcite3-required ignite-3)

> 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
>            Priority: Major
>              Labels: calcite
>
> 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}
> {noformat}
> /sql/aggregate/group/test_group_by.test[_ignore]
> /sql/types/null/test_null_aggr.test[_ignore]
> {noformat}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

Reply via email to