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)
