[
https://issues.apache.org/jira/browse/IGNITE-25253?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-25253:
--------------------------------------
Issue Type: Bug (was: Task)
> 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: Bug
> Components: sql
> Affects Versions: 3.0.0-beta1
> Reporter: Evgeny Stanilovsky
> Assignee: Evgeny Stanilovsky
> Priority: Major
> Labels: ignite-3
> Time Spent: 20m
> Remaining Estimate: 0h
>
> 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)
