Evgeny Stanilovsky created IGNITE-29040:
-------------------------------------------
Summary: NATURAL JOIN query plans too long
Key: IGNITE-29040
URL: https://issues.apache.org/jira/browse/IGNITE-29040
Project: Ignite
Issue Type: Improvement
Components: sql
Affects Versions: 2.18
Reporter: Evgeny Stanilovsky
I found that in current master branch below test run more that 30 sec
git sha : 63457695229c9c4a967ef9eb62cf92
{code:java}
@Test
public void testNonColocatedNaturalJoin() {
sql("CREATE TABLE tbl1 (a INTEGER, b INTEGER, PRIMARY KEY(b));");
sql("CREATE TABLE tbl2 (a INTEGER, c INTEGER, PRIMARY KEY(c));");
sql("CREATE TABLE tbl3 (a INTEGER, b INTEGER, c INTEGER, PRIMARY KEY(a))");
sql("INSERT INTO tbl1 VALUES (1, 2)");
sql("INSERT INTO tbl2 VALUES (1, 3), (2, 4)");
sql("INSERT INTO tbl3 VALUES (1, 2, 3)");
assertQuery("SELECT * FROM tbl1 NATURAL JOIN tbl2 NATURAL JOIN tbl3")
.returns(1, 2, 3)
.check();
}{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
