[jira] [Created] (IGNITE-25275) Sql. Correlated sub-query in ON classes of join cannot be rewritten

[Konstantin Orlov (Jira)]

Konstantin Orlov created IGNITE-25275:
-----------------------------------------

             Summary: Sql. Correlated sub-query in ON classes of join cannot be 
rewritten
                 Key: IGNITE-25275
                 URL: https://issues.apache.org/jira/browse/IGNITE-25275
             Project: Ignite
          Issue Type: Bug
          Components: sql ai3
            Reporter: Konstantin Orlov


This problem is similar to one described in IGNITE-25253, but now correlated 
subquery references the right side of join:
```
        sqlScript(""
                + "CREATE TABLE t0 ("
                + " id INT PRIMARY KEY,"
                + " val INT);"
                + "CREATE TABLE t1 (id INT PRIMARY KEY, val INT);");

        sql("insert into t0 values(1, 10), (2, 20);");
        sql("insert into t1 values(1, 10), (2, 20);");

        assertQuery("SELECT t1.ID FROM t0 JOIN t1 ON "
                + "(t0.id = (SELECT inner_t0.id FROM t0 AS inner_t0 WHERE 
inner_t0.val = t1.val)) ORDER BY 1")
                .matches(containsSubPlan("CorrelatedNestedLoopJoin"))
                .returns(1)
                .returns(2)
                .check();
```



--
This message was sent by Atlassian Jira
(v8.20.10#820010)