Iurii Gerzhedovich created IGNITE-22200:
-------------------------------------------
Summary: 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: Improvement
Components: sql
Reporter: Iurii Gerzhedovich
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)
