[
https://issues.apache.org/jira/browse/IGNITE-14358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17423211#comment-17423211
]
Konstantin Orlov commented on IGNITE-14358:
-------------------------------------------
[~vermakov], I've left a few comments. Please see PR.
> 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
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> 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)
