[jira] [Updated] (IGNITE-16130) Calcite. Natural join returns empty resultset.

2022-02-07 Thread Aleksey Plekhanov (Jira) 


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

Aleksey Plekhanov updated IGNITE-16130:
---
Labels: calcite  (was: calcite calcite2-required calcite3-required ignite-3)

> Calcite. Natural join returns empty resultset.
> --
>
> Key: IGNITE-16130
> URL: https://issues.apache.org/jira/browse/IGNITE-16130
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Reporter: Evgeny Stanilovsky
>Priority: Major
>  Labels: calcite
>
> {noformat}
> statement ok
> CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER);
> statement ok
> CREATE TABLE t2(b INTEGER, c INTEGER, d INTEGER);
> statement ok
> INSERT INTO t1 VALUES(1,2,3);
> statement ok
> INSERT INTO t1 VALUES(2,3,4);
> statement ok
> INSERT INTO t1 VALUES(3,4,5);
> statement ok
> INSERT INTO t2 VALUES(1,2,3);
> statement ok
> INSERT INTO t2 VALUES(2,3,4);
> statement ok
> INSERT INTO t2 VALUES(3,4,5);
> query III rowsort
> SELECT t2.* FROM t2 NATURAL JOIN t1;
> 
> 2 3   4
> 3 4   5
> query III rowsort
> SELECT t1.* FROM t2 NATURAL JOIN t1;
> 
> 1 2   3
> 2 3   4
> query II nosort
> SELECT t1.*, t2.* FROM t2 NATURAL JOIN t1 ORDER BY t1.a
> 
> 1 2   3   2   3   4
> 2 3   4   3   4   5
> {noformat}



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

[jira] [Updated] (IGNITE-16130) Calcite. Natural join returns empty resultset.

2021-12-15 Thread Evgeny Stanilovsky (Jira) 


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

Evgeny Stanilovsky updated IGNITE-16130:

Description: 
{noformat}
statement ok
CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER);

statement ok
CREATE TABLE t2(b INTEGER, c INTEGER, d INTEGER);

statement ok
INSERT INTO t1 VALUES(1,2,3);

statement ok
INSERT INTO t1 VALUES(2,3,4);

statement ok
INSERT INTO t1 VALUES(3,4,5);

statement ok
INSERT INTO t2 VALUES(1,2,3);

statement ok
INSERT INTO t2 VALUES(2,3,4);

statement ok
INSERT INTO t2 VALUES(3,4,5);

query III rowsort
SELECT t2.* FROM t2 NATURAL JOIN t1;

2   3   4
3   4   5

query III rowsort
SELECT t1.* FROM t2 NATURAL JOIN t1;

1   2   3
2   3   4

query II nosort
SELECT t1.*, t2.* FROM t2 NATURAL JOIN t1 ORDER BY t1.a

1   2   3   2   3   4
2   3   4   3   4   5
{noformat}


  was:
{noformat}
statement ok
CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER);

statement ok
CREATE TABLE t2(b INTEGER, c INTEGER, d INTEGER);

statement ok
INSERT INTO t1 VALUES(1,2,3);

statement ok
INSERT INTO t1 VALUES(2,3,4);

statement ok
INSERT INTO t1 VALUES(3,4,5);

statement ok
INSERT INTO t2 VALUES(1,2,3);

statement ok
INSERT INTO t2 VALUES(2,3,4);

statement ok
INSERT INTO t2 VALUES(3,4,5);

query III rowsort
SELECT t2.* FROM t2 NATURAL JOIN t1;

2   3   4
3   4   5

query III rowsort
SELECT t1.* FROM t2 NATURAL JOIN t1;

1   2   3
2   3   4
{noformat}



> Calcite. Natural join returns empty resultset.
> --
>
> Key: IGNITE-16130
> URL: https://issues.apache.org/jira/browse/IGNITE-16130
> Project: Ignite
>  Issue Type: Bug
>  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, c INTEGER);
> statement ok
> CREATE TABLE t2(b INTEGER, c INTEGER, d INTEGER);
> statement ok
> INSERT INTO t1 VALUES(1,2,3);
> statement ok
> INSERT INTO t1 VALUES(2,3,4);
> statement ok
> INSERT INTO t1 VALUES(3,4,5);
> statement ok
> INSERT INTO t2 VALUES(1,2,3);
> statement ok
> INSERT INTO t2 VALUES(2,3,4);
> statement ok
> INSERT INTO t2 VALUES(3,4,5);
> query III rowsort
> SELECT t2.* FROM t2 NATURAL JOIN t1;
> 
> 2 3   4
> 3 4   5
> query III rowsort
> SELECT t1.* FROM t2 NATURAL JOIN t1;
> 
> 1 2   3
> 2 3   4
> query II nosort
> SELECT t1.*, t2.* FROM t2 NATURAL JOIN t1 ORDER BY t1.a
> 
> 1 2   3   2   3   4
> 2 3   4   3   4   5
> {noformat}



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

[jira] [Updated] (IGNITE-16130) Calcite. Natural join returns empty resultset.

2021-12-15 Thread Evgeny Stanilovsky (Jira) 


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

Evgeny Stanilovsky updated IGNITE-16130:

Description: 
{noformat}
statement ok
CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER);

statement ok
CREATE TABLE t2(b INTEGER, c INTEGER, d INTEGER);

statement ok
INSERT INTO t1 VALUES(1,2,3);

statement ok
INSERT INTO t1 VALUES(2,3,4);

statement ok
INSERT INTO t1 VALUES(3,4,5);

statement ok
INSERT INTO t2 VALUES(1,2,3);

statement ok
INSERT INTO t2 VALUES(2,3,4);

statement ok
INSERT INTO t2 VALUES(3,4,5);

query III rowsort
SELECT t2.* FROM t2 NATURAL JOIN t1;

2   3   4
3   4   5

query III rowsort
SELECT t1.* FROM t2 NATURAL JOIN t1;

1   2   3
2   3   4
{noformat}


  was:

{noformat}
statement ok
CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER);

statement ok
CREATE TABLE t2(b INTEGER, c INTEGER, d INTEGER);

statement ok
INSERT INTO t1 VALUES(1,2,3);

statement ok
INSERT INTO t1 VALUES(2,3,4);

statement ok
INSERT INTO t1 VALUES(3,4,5);

statement ok
INSERT INTO t2 VALUES(1,2,3);

statement ok
INSERT INTO t2 VALUES(2,3,4);

statement ok
INSERT INTO t2 VALUES(3,4,5);

query III rowsort
SELECT t2.* FROM t2 NATURAL JOIN t1;

2   3   4
3   4   5
{noformat}



> Calcite. Natural join returns empty resultset.
> --
>
> Key: IGNITE-16130
> URL: https://issues.apache.org/jira/browse/IGNITE-16130
> Project: Ignite
>  Issue Type: Bug
>  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, c INTEGER);
> statement ok
> CREATE TABLE t2(b INTEGER, c INTEGER, d INTEGER);
> statement ok
> INSERT INTO t1 VALUES(1,2,3);
> statement ok
> INSERT INTO t1 VALUES(2,3,4);
> statement ok
> INSERT INTO t1 VALUES(3,4,5);
> statement ok
> INSERT INTO t2 VALUES(1,2,3);
> statement ok
> INSERT INTO t2 VALUES(2,3,4);
> statement ok
> INSERT INTO t2 VALUES(3,4,5);
> query III rowsort
> SELECT t2.* FROM t2 NATURAL JOIN t1;
> 
> 2 3   4
> 3 4   5
> query III rowsort
> SELECT t1.* FROM t2 NATURAL JOIN t1;
> 
> 1 2   3
> 2 3   4
> {noformat}



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