[CALCITE-4512] GROUP BY expression with argument name same with SELECT field and alias causes validation error

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.26.0
• Component/s: core
• Labels: pull-request-available

Environment

jvm: open-jdk8

• Assignee: yanjing.wang
• Reporter: yanjing.wang
• Created: 24/Feb/21 03:11
• Updated: 19/Dec/22 06:21

Description

String sql = "select replace(name, 'a', 'b') as name from users group by replace(name, 'a', 'b')";

 

when group by expression has argument name same with select list item alias, the group by argument will be expanded to select list item when sql conformance supports 'groupByAlias', so the above sql will be expanded to 

String sql = "select replace(name, 'a', 'b') as name from users group by replace(replace(name, 'a', 'b'), 'a', 'b')";

 

this is unexpected.

Issue Links

• Blocked: CALCITE-3589 SqlValidatorException when conformation is set to LENIENT
• blocks: CALCITE-5045 Alias within GroupingSets throws type mis-match exception
• links to: GitHub Pull Request #2745