[ https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Hyde updated CALCITE-4512: --------------------------------- Fix Version/s: 1.33.0 (was: 1.32.0) > GROUP BY expression with argument name same with SELECT field and alias > causes validation error > ----------------------------------------------------------------------------------------------- > > Key: CALCITE-4512 > URL: https://issues.apache.org/jira/browse/CALCITE-4512 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.26.0 > Environment: jvm: open-jdk8 > Reporter: yanjing.wang > Assignee: yanjing.wang > Priority: Major > Labels: pull-request-available > Fix For: 1.33.0 > > Time Spent: 2h 40m > Remaining Estimate: 0h > > 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. -- This message was sent by Atlassian Jira (v8.20.10#820010)