[ https://issues.apache.org/jira/browse/CALCITE-2977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16809618#comment-16809618 ]
pengzhiwei commented on CALCITE-2977: ------------------------------------- I prefer to allow the case that the ambiguous field is not referenced and throw exception for that is referenced.A PR is made for this issue,please have a review,thanks! PS: I also fix same test case which enable the _CaseSensitive_ to _true_ ,But use the default _UnquotedCasing TO_UPPER,_ which make all identifier to upper and make the test for case-sensitive no meaning. . > Exception is not thrown out when there are ambiguous field in select list > -------------------------------------------------------------------------- > > Key: CALCITE-2977 > URL: https://issues.apache.org/jira/browse/CALCITE-2977 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.20.0 > Reporter: pengzhiwei > Assignee: pengzhiwei > Priority: Major > Labels: pull-request-available > Fix For: 1.20.0 > > Time Spent: 10m > Remaining Estimate: 0h > > In the following sql: > {code:java} > select t0 from (select 1 as t0, 2 as t0 from dept){code} > _SqlValidatorImpl_ does not throw an exception for the ambiguous field "t0". > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)