[jira] [Created] (IGNITE-14885) Calcite engine. Allow grouping by alias or ordinal

["Aleksey Plekhanov (Jira)" <ji...@apache.org>]

Aleksey Plekhanov created IGNITE-14885:
------------------------------------------

             Summary: Calcite engine. Allow grouping by alias or ordinal
                 Key: IGNITE-14885
                 URL: https://issues.apache.org/jira/browse/IGNITE-14885
             Project: Ignite
          Issue Type: Improvement
            Reporter: Aleksey Plekhanov


Currently, grouping by alias or ordinal is not supported, but sometimes it can be handy. 

Some DB vendors support this feature (PostgreSQL, MySQL), but some not (Oracle, MSSQL). In the current Ignite H2-based SQL engine, this feature is not supported. We should decide do we need it in Ignite with calcite-based SQL engine.

This feature can be easily enabled by redefining {{SqlConformance#isGroupByAlias}}, {{SqlConformance#isGroupByOrdinal}}

Affected tests:
{{src/test/sql/aggregate/group/test_group_by.test}}
{{src/test/sql/aggregate/group/test_group_by_alias.test}}
And many other.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)