[
https://issues.apache.org/jira/browse/IGNITE-16003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky updated IGNITE-16003:
----------------------------------------
Labels: calcite calcite2-required calcite3-required (was: )
> 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
> Priority: Major
> Labels: calcite, calcite2-required, calcite3-required
>
> 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)
