[jira] [Updated] (IGNITE-15808) Calcite engine. Failed to join table with itself with 'USING' clause

2022-02-07 Thread Aleksey Plekhanov (Jira)


 [ 
https://issues.apache.org/jira/browse/IGNITE-15808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Aleksey Plekhanov updated IGNITE-15808:
---
Labels: calcite  (was: calcite calcite2-required calcite3-required)

> Calcite engine. Failed to join table with itself with 'USING' clause
> 
>
> Key: IGNITE-15808
> URL: https://issues.apache.org/jira/browse/IGNITE-15808
> Project: Ignite
>  Issue Type: Bug
>Reporter: Aleksey Plekhanov
>Priority: Major
>  Labels: calcite
>
> Statement:
> {noformat}
> CREATE TABLE test (t INT);
> SELECT * FROM test t1 JOIN test t2 USING (t){noformat}
> Failed with: 
> {noformat}
> java.lang.ArrayIndexOutOfBoundsException: 2
> {noformat}
> But statement:
> {noformat}
> CREATE TABLE test (t INT);
> CREATE TABLE test2 (t INT);
> SELECT * FROM test t1 JOIN test2 t2 USING (t){noformat}
> Works.
>  



--
This message was sent by Atlassian Jira
(v8.20.1#820001)


[jira] [Updated] (IGNITE-15808) Calcite engine. Failed to join table with itself with 'USING' clause

2021-10-25 Thread Aleksey Plekhanov (Jira)


 [ 
https://issues.apache.org/jira/browse/IGNITE-15808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Aleksey Plekhanov updated IGNITE-15808:
---
Description: 
Statement:
{noformat}
CREATE TABLE test (t INT);
SELECT * FROM test t1 JOIN test t2 USING (t){noformat}
Failed with: 
{noformat}
java.lang.ArrayIndexOutOfBoundsException: 2
{noformat}
But statement:
{noformat}
CREATE TABLE test (t INT);
CREATE TABLE test2 (t INT);
SELECT * FROM test t1 JOIN test2 t2 USING (t){noformat}
Works.

 

  was:
 

Statement:
{noformat}
CREATE TABLE test (t INT);
SELECT * FROM test t1 JOIN test t2 USING (t){noformat}
Failed with:

 

 
{noformat}
java.lang.ArrayIndexOutOfBoundsException: 2
{noformat}
But statement:

 
{noformat}
CREATE TABLE test (t INT);
CREATE TABLE test2 (t INT);
SELECT * FROM test t1 JOIN test2 t2 USING (t){noformat}
Works.

 


> Calcite engine. Failed to join table with itself with 'USING' clause
> 
>
> Key: IGNITE-15808
> URL: https://issues.apache.org/jira/browse/IGNITE-15808
> Project: Ignite
>  Issue Type: Bug
>Reporter: Aleksey Plekhanov
>Priority: Major
>  Labels: calcite, calcite2-required, calcite3-required
>
> Statement:
> {noformat}
> CREATE TABLE test (t INT);
> SELECT * FROM test t1 JOIN test t2 USING (t){noformat}
> Failed with: 
> {noformat}
> java.lang.ArrayIndexOutOfBoundsException: 2
> {noformat}
> But statement:
> {noformat}
> CREATE TABLE test (t INT);
> CREATE TABLE test2 (t INT);
> SELECT * FROM test t1 JOIN test2 t2 USING (t){noformat}
> Works.
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)