[
https://issues.apache.org/jira/browse/IGNITE-22200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov reassigned IGNITE-22200:
-----------------------------------------
Assignee: Maksim Zhuravkov
> Sql. Error in case combine CTE and SET operation
> ------------------------------------------------
>
> Key: IGNITE-22200
> URL: https://issues.apache.org/jira/browse/IGNITE-22200
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Iurii Gerzhedovich
> Assignee: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
>
> For the simple query below, where the result of select is combined with the
> result of CTE query we got an unexpected error.
> {code:java}
> SELECT 1 UNION ALL (WITH cte AS (SELECT 42) SELECT * FROM cte); {code}
> {code:java}
> aused by: java.lang.AssertionError
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.deduceModality(SqlValidatorImpl.java:4092)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateModality(SqlValidatorImpl.java:4073)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1135)
> at
> org.apache.calcite.sql.SqlSetOperator.validateCall(SqlSetOperator.java:90)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateCall(SqlValidatorImpl.java:6232)
> at org.apache.calcite.sql.SqlCall.validate(SqlCall.java:143)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1091)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:797)
> at
> org.apache.ignite.internal.sql.engine.prepare.IgniteSqlValidator.validate(IgniteSqlValidator.java:180)
> at
> org.apache.ignite.internal.sql.engine.prepare.IgnitePlanner.validateAndGetTypeMetadata(IgnitePlanner.java:283)
> at
> org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.lambda$prepareQuery$2(PrepareServiceImpl.java:312)
> at
> java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
