You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Vladimir Steshin (Jira)" <ji...@apache.org> on 2021/12/08 13:17:00 UTC

[jira] [Created] (CALCITE-4926) 'ORDER BY' misses alias/table of own 'WITH'

Vladimir Steshin created CALCITE-4926:
-----------------------------------------

             Summary: 'ORDER BY' misses alias/table of own 'WITH'
                 Key: CALCITE-4926
                 URL: https://issues.apache.org/jira/browse/CALCITE-4926
             Project: Calcite
          Issue Type: Bug
            Reporter: Vladimir Steshin


"SELECT * FROM emp ORDER BY (WITH t AS (SELECT 1) SELECT * FROM t)"
fails with:
"Column 'T' not found in any table". 

Working similar one:
"WITH t AS (SELECT 1) SELECT * FROM emp ORDER BY (SELECT * FROM t)"

As I understand, SqlValidatorImpl#OrderExpressionExpander (extends SqlScopedShuttle) hurries to find the alias in the upper, parent query, whole "select * from ...". But this query and the related namespaces has no such alias. Probably, it's better to search order-by's namespace first.



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