[
https://issues.apache.org/jira/browse/IGNITE-29040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky updated IGNITE-29040:
----------------------------------------
Labels: idea ignite-2 ise (was: ignite-2 ise)
> 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
> Priority: Major
> Labels: idea, ignite-2, ise
>
> 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
(v10.3.26#10030026)
