[ https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
yanjing.wang updated CALCITE-4512: ---------------------------------- Fix Version/s: (was: 1.33.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 > Time Spent: 2h 40m > Remaining Estimate: 0h > > {code:java} > String sql = "select replace(name, 'a', 'b') as name from users group by > replace(name, 'a', 'b')"; > {code} > > 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 > {code:java} > String sql = "select replace(name, 'a', 'b') as name from users group by > replace(replace(name, 'a', 'b'), 'a', 'b')"; > {code} > > this is unexpected. -- This message was sent by Atlassian Jira (v8.20.10#820010)