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

["Konstantin Orlov (Jira)" <ji...@apache.org>]

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

Konstantin Orlov commented on IGNITE-16040:
-------------------------------------------

The fix has been merged to the Calcite and should be released within 1.31. So, let's wait until the release and check if the planner could handle the query from description.

> 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.7#820007)