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 IIIIII 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
IGNITE-12248 Apache Calcite based query execution engine
