[jira] [Created] (IGNITE-15995) Calcite engine. Order by subquery containing WITH clause failed

[Aleksey Plekhanov (Jira)]

Aleksey Plekhanov created IGNITE-15995:
------------------------------------------

             Summary: Calcite engine. Order by subquery containing WITH clause 
failed
                 Key: IGNITE-15995
                 URL: https://issues.apache.org/jira/browse/IGNITE-15995
             Project: Ignite
          Issue Type: Bug
            Reporter: Aleksey Plekhanov


For example:
{noformat}
SELECT * FROM (SELECT 1) ORDER BY (WITH t AS (SELECT 1) SELECT * FROM t)
{noformat}
Fail with error:
{noformat}
Failed to validate query. org.apache.calcite.runtime.CalciteContextException: 
At line 1, column 58: Column 'T' not found in any table
{noformat}
Related tests: {{test_correlated_subquery_cte.test_ignore}}




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