[IGNITE-14189] Cannot reference CTE from within derived table

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.9.1
• Component/s: sql
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Lukas Eder
• Created: 16/Feb/21 07:57
• Updated: 16/Feb/21 07:57

Description

The following query doesn't work:

WITH t(a, b) AS (SELECT 1, 'a')
SELECT *
FROM (SELECT * FROM t) t;

It produces this error:

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]