[
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)
