[
https://issues.apache.org/jira/browse/CALCITE-7589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Nuyanzin updated CALCITE-7589:
-------------------------------------
Description:
Seems to be a regression after CALCITE-6413
example of failing query
{code:sql}
SELECT * FROM emp JOIN dept USING(deptno)
{code}
fails as
{noformat}
java.lang.AssertionError
at
org.apache.calcite.sql.validate.SqlValidatorImpl.getTypeCoercion(SqlValidatorImpl.java:5133)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertUsing(SqlToRelConverter.java:3646)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertUsingCondition(SqlToRelConverter.java:3553)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertJoin(SqlToRelConverter.java:3492)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:2644)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:2523)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:758)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:738)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:4149)
at
org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:631)
at
org.apache.calcite.sql.test.AbstractSqlTester.convertSqlToRel2(AbstractSqlTester.java:570)
at
org.apache.calcite.sql.test.AbstractSqlTester.assertSqlConvertsTo(AbstractSqlTester.java:511)
at
org.apache.calcite.sql.test.AbstractSqlTester.assertConvertsTo(AbstractSqlTester.java:489)
at
org.apache.calcite.test.SqlToRelFixture.convertsTo(SqlToRelFixture.java:106)
at org.apache.calcite.test.SqlToRelFixture.ok(SqlToRelFixture.java:94)
{noformat}
was:
Seems to be a regression after CALCITE-6413
example of failing query
{code:sql}
SELECT * FROM emp JOIN dept USING(deptno)
{code}
> JOIN ... USING might fail with disabled type coercion
> -----------------------------------------------------
>
> Key: CALCITE-7589
> URL: https://issues.apache.org/jira/browse/CALCITE-7589
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: Sergey Nuyanzin
> Assignee: Sergey Nuyanzin
> Priority: Major
>
> Seems to be a regression after CALCITE-6413
> example of failing query
> {code:sql}
> SELECT * FROM emp JOIN dept USING(deptno)
> {code}
> fails as
> {noformat}
> java.lang.AssertionError
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.getTypeCoercion(SqlValidatorImpl.java:5133)
> at
> org.apache.calcite.sql2rel.SqlToRelConverter.convertUsing(SqlToRelConverter.java:3646)
> at
> org.apache.calcite.sql2rel.SqlToRelConverter.convertUsingCondition(SqlToRelConverter.java:3553)
> at
> org.apache.calcite.sql2rel.SqlToRelConverter.convertJoin(SqlToRelConverter.java:3492)
> at
> org.apache.calcite.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:2644)
> at
> org.apache.calcite.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:2523)
> at
> org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:758)
> at
> org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:738)
> at
> org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:4149)
> at
> org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:631)
> at
> org.apache.calcite.sql.test.AbstractSqlTester.convertSqlToRel2(AbstractSqlTester.java:570)
> at
> org.apache.calcite.sql.test.AbstractSqlTester.assertSqlConvertsTo(AbstractSqlTester.java:511)
> at
> org.apache.calcite.sql.test.AbstractSqlTester.assertConvertsTo(AbstractSqlTester.java:489)
> at
> org.apache.calcite.test.SqlToRelFixture.convertsTo(SqlToRelFixture.java:106)
> at org.apache.calcite.test.SqlToRelFixture.ok(SqlToRelFixture.java:94)
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
