Maksim Zhuravkov created CALCITE-6413: -----------------------------------------
Summary: SqlValidator does not invoke type coercion for both NATURAL and USING join conditions Key: CALCITE-6413 URL: https://issues.apache.org/jira/browse/CALCITE-6413 Project: Calcite Issue Type: Improvement Reporter: Maksim Zhuravkov This can be observed by adding these test cases to `SqlToRelConverterTest`: 1. Join condition ON expression {code:java} @Test void test1() { final String sql = "select * from emp JOIN (VALUES ('XXX')) t(deptno) ON emp.deptno = t.deptno"; sql(sql).ok(); } {code} 2. Common columns (USING/NATURAL) (since they both share the same code path for building join condition) {code:java} @Test void test2() { final String sql = "select * from emp JOIN (VALUES ('XXX')) t(deptno) USING (deptno)"; sql(sql).ok(); } {code} When test 1 runs, the SqlValidator calls TypeCoercionImpl::binaryComparisonCoercion When test 2 runs, the SqlValidator does not call TypeCoercionImpl::binaryComparisonCoercion. -- This message was sent by Atlassian Jira (v8.20.10#820010)