[IGNITE-19125] Sql. Expected errors on joins are not rised after bump calcite version to 1.34

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0-beta1
• Component/s: sql
• Labels: calcite3-required ignite-3
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 27/Mar/23 10:18
• Updated: 31/Mar/23 07:52

Description

After version was bumped [1], some expected errors are not rised:

/join/inner/test_using_join.test_ignore

statement error
SELECT * FROM t1 JOIN t2 USING(a) JOIN t2 t2b USING (b);

# this is the same, but now with a duplicate potential binding on the RHS
statement error
select * from (values (1)) tbl(i) join ((values (1)) tbl2(i) join  (values (1)) tbl3(i) on tbl2.i=tbl3.i) using (i)

In caclite 1.32 it works properly well. Probably it was broken by [2]

[1] https://issues.apache.org/jira/browse/IGNITE-18752
[2] https://issues.apache.org/jira/browse/CALCITE-5253