[
https://issues.apache.org/jira/browse/IGNITE-14358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17421998#comment-17421998
]
Ignite TC Bot commented on IGNITE-14358:
----------------------------------------
{panel:title=Branch: [pull/9441/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/9441/head] Base: [master] : New Tests
(10)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Queries 1{color} [[tests
10|https://ci.ignite.apache.org/viewLog.html?buildId=6200739]]
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testOptimizationAliasUnion - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testOptimizationLeftJoinWhereFalse3 -
PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testOptimizationLeftJoinWhereFalse2 -
PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testOptimizationConstant2 - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testOptimizationConstant1 - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testOptimizationAlias2 - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testOptimizationAlias1 - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testOptimizationCaseWhen - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testOptimizationCastFunction - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testOptimizationLeftJoinWhereFalse -
PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci.ignite.apache.org/viewLog.html?buildId=6200761&buildTypeId=IgniteTests24Java8_RunAll]
> 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: 20m
> 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)
