Lukas Eder created IGNITE-14040:
-----------------------------------
Summary: NATURAL JOIN not implemented correctly
Key: IGNITE-14040
URL: https://issues.apache.org/jira/browse/IGNITE-14040
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 2.9.1
Reporter: Lukas Eder
Try this:
{code:java}
CREATE TABLE t1 (i int PRIMARY KEY, j int);
CREATE TABLE t2 (i int PRIMARY KEY, k int);
INSERT INTO t1 VALUES (1, 1), (2, 2);
INSERT INTO t2 VALUES (2, 2), (3, 3);
SELECT * FROM t1 NATURAL JOIN t2;
{code}
It doesn't yield any results, when we should be getting:
{noformat}
|I |J |K |
|--|--|--|
|2 |2 |2 |{noformat}
The explain plan on the SELECT seems to hint at keys and values being compared
{code:java}
SELECT
__Z0.I AS __C0_0,
__Z0.J AS __C0_1,
__Z1.K AS __C0_2
FROM PUBLIC.T1 __Z0
/* PUBLIC.T1.__SCAN_ */
INNER JOIN PUBLIC.T2 __Z1
/* PUBLIC."_key_PK": _KEY = PUBLIC.__Z0._KEY */
ON 1=1
WHERE (PUBLIC.__Z0.I = PUBLIC.__Z1.I)
AND ((PUBLIC.__Z0._KEY = PUBLIC.__Z1._KEY)
AND (PUBLIC.__Z0._VAL = PUBLIC.__Z1._VAL)){code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
