[ https://issues.apache.org/jira/browse/CALCITE-3589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16997842#comment-16997842 ]
bingfeng.guo edited comment on CALCITE-3589 at 12/17/19 12:26 PM: ------------------------------------------------------------------ @[~julianhyde] Thanks for your review,you means the following situations? I try the case you say in postgresql,The result of postgresql is the same as what you say {code:java} select tablex.A+tabley.A as A from tablex,tabley group by A ERROR: column reference "a" is ambiguou {code} was (Author: bingfeng): @[~julianhyde] Thanks for your review,Are you considering the following situations? I try the case you say in postgresql,The result of postgresql is the same as what you say {code:java} select tablex.A+tabley.A as A from tablex,tabley group by A ERROR: column reference "a" is ambiguou {code} > SqlValidatorException when conformation is set to LENIENT > --------------------------------------------------------- > > Key: CALCITE-3589 > URL: https://issues.apache.org/jira/browse/CALCITE-3589 > Project: Calcite > Issue Type: Bug > Reporter: bingfeng.guo > Assignee: bingfeng.guo > Priority: Critical > Labels: pull-request-available > Attachments: 屏幕快照 2019-12-12 下午5.56.24.png > > Time Spent: 1h > Remaining Estimate: 0h > > error occurs conditions (all three conditions must be met): > * conformance = LENIENT > * The alias of the expression in select is the same as the column name of > the column used in the expression > * group by or having use the above expression > {color:#172b4d}a simple example is as follows:{color} > {color:#ff8b00}SELECT SELLER_ID + 1 AS SELLER_ID, sum(PRICE){color} > {color:#ff8b00}FROM TEST_KYLIN_FACT{color} > {color:#ff8b00}GROUP BY SELLER_ID + 1{color} > {color:#172b4d}will change to {color} > {color:#ff8b00}SELECT SELLER_ID + 1 AS SELLER_ID, sum(PRICE){color} > {color:#ff8b00} FROM TEST_KYLIN_FACT{color} > {color:#ff8b00} GROUP BY SELLER_ID + 1 + 1{color} > {color:#172b4d}after > org.apache.calcite.sql.validate.SqlValidatorImpl#expandGroupByOrHavingExpr{color} > > -- This message was sent by Atlassian Jira (v8.3.4#803005)