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

["Yury Gerzhedovich (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-14358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17419262#comment-17419262 ] 

Yury Gerzhedovich commented on IGNITE-14358:
--------------------------------------------

Apparently, this is a consequence resolving of the ticket IGNITE-10306.

> 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
>            Priority: Major
>
> 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)