You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Ermakov (Jira)" <ji...@apache.org> on 2021/09/24 08:50:00 UTC

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

     [ https://issues.apache.org/jira/browse/IGNITE-14358?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vladimir Ermakov reassigned IGNITE-14358:
-----------------------------------------

    Assignee: Vladimir Ermakov

> 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
>            Assignee: Vladimir Ermakov
>            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)