[ https://issues.apache.org/jira/browse/IGNITE-16040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17598201#comment-17598201 ]
Evgeny Stanilovsky commented on IGNITE-16040: --------------------------------------------- [~jooger] what tests you are talking about ? did i miss smt? > Calcite. Unable to plan query with several correlated sub-queries in select > list > -------------------------------------------------------------------------------- > > Key: IGNITE-16040 > URL: https://issues.apache.org/jira/browse/IGNITE-16040 > Project: Ignite > Issue Type: Bug > Components: sql > Reporter: Konstantin Orlov > Assignee: Evgeny Stanilovsky > Priority: Major > Labels: calcite, calcite2-required, calcite3-required > Time Spent: 20m > Remaining Estimate: 0h > > Currently the query like below can't be planned by calcite-based sql engine: > {code:java} > SELECT a+b*2, > (a+b+c+d+e)/5, > (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d), > (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), > abs(b-c), > a-b > FROM t1 > WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) > AND c>d > ORDER BY 6,5,4,1,3,2 > {code} > Need to figure it out how to fix this. -- This message was sent by Atlassian Jira (v8.20.10#820010)