Lukas Eder created IGNITE-14189: ----------------------------------- Summary: Cannot reference CTE from within derived table Key: IGNITE-14189 URL: https://issues.apache.org/jira/browse/IGNITE-14189 Project: Ignite Issue Type: Bug Components: sql Affects Versions: 2.9.1 Reporter: Lukas Eder
The following query doesn't work: {code:java} WITH t(a, b) AS (SELECT 1, 'a') SELECT * FROM (SELECT * FROM t) t;{code} It produces this error: {noformat} SQL Error [1001] [42000]: Failed to parse query. Column "T.A" not found; SQL statement: CREATE FORCE VIEW PUBLIC._352 AS SELECT T.A, T.B FROM ( SELECT 1, 'a' FROM SYSTEM_RANGE(1, 1) ) T [42122-197]{noformat} -- This message was sent by Atlassian Jira (v8.3.4#803005)