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

Posted to issues@ignite.apache.org by "Lukas Eder (Jira)" <ji...@apache.org> on 2021/02/16 07:58:00 UTC

[jira] [Created] (IGNITE-14189) Cannot reference CTE from within derived table

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)