Analyzer: Expression can not be resolved from parent scope #71659
Description
Company or project name
ClickHouse inc.
Describe what's wrong
Identifiers from the nested CTE are not evaluated properly.
Does it reproduce on the most recent release?
Yes.
How to reproduce
CREATE TABLE test
(
a UInt64,
b UInt64,
)
ENGINE = MergeTree
ORDER BY tuple();
SET allow_experimental_analyzer=1;
WITH
(a > b) as cte,
query AS
(
SELECT count()
FROM test
WHERE cte
)
SELECT *
FROM query;
Error message and/or stacktrace
Received exception from server (version 24.10.1):
Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown expression or function identifier `a` in scope WITH a > b AS cte, query AS (SELECT count() FROM test WHERE cte) SELECT * FROM query. (UNKNOWN_IDENTIFIER)
(query: WITH
(a > b) as cte,
query AS
(
SELECT count()
FROM test
WHERE cte
)
SELECT *
FROM query;)