Xiong Tenghui created CALCITE-7051:
--------------------------------------
Summary: In JOIN ... USING, select common columns should not be
failed when set caseSensitive as false
Key: CALCITE-7051
URL: https://issues.apache.org/jira/browse/CALCITE-7051
Project: Calcite
Issue Type: Bug
Components: core
Reporter: Xiong Tenghui
In JOIN ... USING, if have set caseSensitive as false(and
quotedCasing,unquotedCasing=CHANGED), common columns should be success
regardless of case. For example, the following 4 queries are valid on Presto,
and both of them maybe failed, it depends on the case of column name in
catalog. In each case, {{DEPTNO}} is the common column.
{code:java}
select DEPTNO from emp join dept using (DEPTNO);
select deptno from emp join dept using (deptno);
select DEPTNO from emp join dept using (deptno);
select deptno from emp join dept using (DEPTNO); {code}
I think it is because that caseSensitive is not handled well in the following
method.
https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/sql/validate/SqlValidatorImpl.java#L529
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
