You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Aleksey Plekhanov (Jira)" <ji...@apache.org> on 2021/12/03 13:21:00 UTC
[jira] [Commented] (IGNITE-15573) Calcite. NATURAL JOIN fails.
[ https://issues.apache.org/jira/browse/IGNITE-15573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17452999#comment-17452999 ]
Aleksey Plekhanov commented on IGNITE-15573:
--------------------------------------------
Most of the problems will be solved with IGNITE-15569, but there are some issues left, which should be solved in Calcite tickets: CALCITE-4915, CALCITE-4921
> Calcite. NATURAL JOIN fails.
> ----------------------------
>
> Key: IGNITE-15573
> URL: https://issues.apache.org/jira/browse/IGNITE-15573
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Evgeny Stanilovsky
> Priority: Major
> Labels: calcite, calcite2-required, calcite3-required, ignite-3
>
> {noformat}
> statement ok
> CREATE TABLE t1 (a INTEGER, b INTEGER)
> statement ok
> INSERT INTO t1 VALUES (1, 2)
> statement ok
> CREATE TABLE t2 (a INTEGER, c INTEGER)
> statement ok
> INSERT INTO t2 VALUES (1, 3), (2, 4)
> query III
> SELECT * FROM t1 NATURAL JOIN t2
> ----
> 1 2 3
> {noformat}
> fails with
> {noformat}
> java.lang.ArrayIndexOutOfBoundsException: 4
> at com.google.common.collect.RegularImmutableList.get(RegularImmutableList.java:60)
> at org.apache.calcite.sql.validate.SqlValidatorImpl$Permute.permute(SqlValidatorImpl.java:7089)
> at org.apache.calcite.sql.validate.SqlValidatorImpl.expandStar(SqlValidatorImpl.java:662)
> at org.apache.calcite.sql.validate.SqlValidatorImpl.expandSelectItem(SqlValidatorImpl.java:424)
> at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelectList(SqlValidatorImpl.java:4414)
> at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3657)
> at org.apache.ignite.internal.processors.query.calcite.prepare.IgniteSqlValidator.validateSelect(IgniteSqlValidator.java:182)
> {noformat}
> {noformat}
> /join/natural/natural_join.test[_ignored]
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)