[
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 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
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
