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)
