[jira] [Created] (IGNITE-16003) Calcite. Set of correlated queries can`t be planned.

["Evgeny Stanilovsky (Jira)" <ji...@apache.org>]

Evgeny Stanilovsky created IGNITE-16003:
-------------------------------------------

             Summary: Calcite. Set of correlated queries can`t be planned.
                 Key: IGNITE-16003
                 URL: https://issues.apache.org/jira/browse/IGNITE-16003
             Project: Ignite
          Issue Type: Bug
            Reporter: Evgeny Stanilovsky
            Assignee: Evgeny Stanilovsky


For example :
{noformat}
statement ok
CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER, d INTEGER, e INTEGER)

statement ok
INSERT INTO t1(e,d,c,b,a) VALUES(246,248,247,249,245)

query IIIII nosort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d),
       c,
       (a+b+c+d+e)/5,
       a+b*2,
       c-d
  FROM t1
 WHERE (a>b-2 AND a<b+2)
   AND e+d BETWEEN a+b-10 AND c+130
   AND d NOT BETWEEN 110 AND 150
 ORDER BY 5,3,2,4,1
----
{noformat}

Also in scope of this issue we need to refactor correlate execution.




--
This message was sent by Atlassian Jira
(v8.20.1#820001)