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/03/19 13:46:00 UTC

[jira] [Created] (IGNITE-14358) Regression when referencing aliased constant from derived table

Lukas Eder created IGNITE-14358:
-----------------------------------

             Summary: Regression when referencing aliased constant from derived table
                 Key: IGNITE-14358
                 URL: https://issues.apache.org/jira/browse/IGNITE-14358
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.10
            Reporter: Lukas Eder


This used to work in 2.9.1 but no longer does in 2.10.0:

 
{code:java}
CREATE TABLE t (i int PRIMARY KEY, j int);
INSERT INTO t VALUES (1, 1);
SELECT u.x
FROM (
 SELECT 1 AS x
 FROM t
) u;
{code}
 

The error I'm getting is:
{noformat}
SQL Error [1001] [42000]: Failed to parse query. Column "U__Z0.X" not found; SQL statement:
SELECT
U__Z0.X
FROM PUBLIC.T U__Z0 [42122-197]{noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)