You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Evgeny Stanilovsky (Jira)" <ji...@apache.org> on 2021/12/15 08:31:00 UTC
[jira] [Created] (IGNITE-16130) Calcite. Natural join returns empty resultset.
Evgeny Stanilovsky created IGNITE-16130:
-------------------------------------------
Summary: 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
{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}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)