[
https://issues.apache.org/jira/browse/IGNITE-25253?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky reassigned IGNITE-25253:
-------------------------------------------
Assignee: Evgeny Stanilovsky
> 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
> Assignee: Evgeny Stanilovsky
> Priority: Major
> Labels: ignite-3
>
> 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)
