Aleksey Plekhanov created IGNITE-22738:
------------------------------------------
Summary: Sql. Select from several nested subqueries fails when
aliases are used
Key: IGNITE-22738
URL: https://issues.apache.org/jira/browse/IGNITE-22738
Project: Ignite
Issue Type: Bug
Reporter: Aleksey Plekhanov
Assignee: Aleksey Plekhanov
Query:
{noformat}
select * from (select * from (select age as a from person) where a > 10)
{noformat}
Fails with an assertion:
{noformat}
at
org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.normalizeExpression(GridSqlQuerySplitter.java:1485)
at
org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.normalizeExpression(GridSqlQuerySplitter.java:1473)
at
org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.normalizeQuery(GridSqlQuerySplitter.java:1364)
at
org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.split0(GridSqlQuerySplitter.java:278)
at
org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.split(GridSqlQuerySplitter.java:219)
at
org.apache.ignite.internal.processors.query.h2.QueryParser.parseH2(QueryParser.java:489)
at
org.apache.ignite.internal.processors.query.h2.QueryParser.parse0(QueryParser.java:222)
at
org.apache.ignite.internal.processors.query.h2.QueryParser.parse(QueryParser.java:135)
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
