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

["Vladimir Steshin (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-15995?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vladimir Steshin updated IGNITE-15995:
--------------------------------------
    Priority: Minor  (was: Major)

> 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
>            Assignee: Vladimir Steshin
>            Priority: Minor
>              Labels: calcite2-required, calcite3-required
>
> 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)