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

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

Konstantin Orlov created IGNITE-16040:
-----------------------------------------

             Summary: 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


Currently the query like below can't be planned 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.1#820001)