[IGNITE-14885] Calcite engine. Allow grouping by alias or ordinal

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: calcite2-required
• Assignee: Unassigned
• Reporter: Aleksey Plekhanov
• Created: 10/Jun/21 09:44
• Updated: 07/Aug/23 07:23

Description

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.

Issue Links

• is part of: IGNITE-14535 Caclite SQL engine capabilities
• relates to: IGNITE-15583 Calcite. Column not found error with correlated sub query.
• relates to: IGNITE-18212 GROUP BY with alias causes column not found in any table error