Sergey Nuyanzin created CALCITE-7940:
----------------------------------------
Summary: AssertionError when selecting a common column of three
tables joined with USING
Key: CALCITE-7940
URL: https://issues.apache.org/jira/browse/CALCITE-7940
Project: Calcite
Issue Type: Bug
Reporter: Sergey Nuyanzin
Assignee: Sergey Nuyanzin
example of query
{code:sql}
select deptno from emp
join dept using (deptno)
join dept as d2 using (deptno)
{code}
{noformat}
org.opentest4j.AssertionFailedError: Validator threw unexpected exception;
query [select deptno from emp
join dept using (deptno)
join dept as d2 using (deptno)]; exception [null]; class [class
java.lang.AssertionError]; pos [line -1 col -1 thru line -1 col -1]
at
app//org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38)
at app//org.junit.jupiter.api.Assertions.fail(Assertions.java:138)
at app//org.apache.calcite.sql.test.SqlTests.checkEx(SqlTests.java:363)
{noformat}
the query passes in PostgreSQL, DuckDB
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)