[jira] [Created] (IGNITE-25253) Sql. Correlated query failed with: Required columns {3} not subset of left columns {0, 1, 2}

[Evgeny Stanilovsky (Jira)]

Evgeny Stanilovsky created IGNITE-25253:
-------------------------------------------

             Summary: Sql. Correlated query failed with: Required columns {3} 
not subset of left columns {0, 1, 2}
                 Key: IGNITE-25253
                 URL: https://issues.apache.org/jira/browse/IGNITE-25253
             Project: Ignite
          Issue Type: Task
          Components: sql
    Affects Versions: 3.0.0-beta1
            Reporter: Evgeny Stanilovsky


Below query is failed:
{noformat}
    @Test
    void test2() {
        sqlScript(""
                + "CREATE TABLE t0 (" 
                + " id INT PRIMARY KEY," 
                + " padding_col1 INT,"
                + " padding_col2 INT,"
                + " val INT);"
                + "CREATE TABLE t1 (id INT PRIMARY KEY, val INT);");

        sql("SELECT t1.ID FROM t0 JOIN t1 ON (t1.id = (SELECT inner_t1.id FROM 
t1 AS inner_t1 WHERE inner_t1.val = t0.val))");
    }{noformat}



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