[ https://issues.apache.org/jira/browse/IGNITE-14885?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yury Gerzhedovich updated IGNITE-14885: --------------------------------------- Labels: calcite2-required calcite3-required (was: ) > 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 > Priority: Major > Labels: calcite2-required, calcite3-required > > 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)