[jira] [Commented] (IGNITE-16040) Calcite. Unable to plan query with several correlated sub-queries in select list

["Yury Gerzhedovich (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-16040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17573631#comment-17573631 ] 

Yury Gerzhedovich commented on IGNITE-16040:
--------------------------------------------

Also we need to unmute tests related to the bug

> 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: Konstantin Orlov
>            Priority: Major
>              Labels: calcite, calcite2-required, calcite3-required
>
> 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)