Aleksey Plekhanov created IGNITE-15992:
------------------------------------------
Summary: Calcite engine. Correlated queries with ORDER and LIMIT
can't be planned
Key: IGNITE-15992
URL: https://issues.apache.org/jira/browse/IGNITE-15992
Project: Ignite
Issue Type: Bug
Reporter: Aleksey Plekhanov
For example:
{noformat}
CREATE TABLE test (a INTEGER)
SELECT (SELECT test.a FROM test t ORDER BY 1 LIMIT 1) FROM test
{noformat}
Fail with:
{noformat}
org.apache.calcite.plan.RelOptPlanner$CannotPlanException: There are not enough
rules to produce a node with desired properties
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
