[
https://issues.apache.org/jira/browse/IGNITE-22866?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Igor updated IGNITE-22866:
--------------------------
Description:
*Description:*
Need to support recursive queries.
The query
{code:java}
WITH RECURSIVE t(n) AS (SELECT 1 UNION ALL SELECT n + 1 FROM t WHERE n < 100)
SELECT sum(n) FROM t; {code}
should return
{code:java}
5050 {code}
currently returns error
{code:java}
Invalid SQL statement type. Expected [DML, DDL] but got QUERY {code}
was:
*Description:*
Need to support recursive queries.
The query
{code:java}
WITH RECURSIVE t(n) AS (SELECT 1 UNION ALL SELECT n + 1 FROM t WHERE n < 100)
SELECT sum(n) FROM t; {code}
should return
{code:java}
5050 {code}
currently returns error
{code:java}
Invalid SQL statement type. Expected [DML, DDL] but got QUERY {code}
> Support WITH RECURSIVE ... AS
> -----------------------------
>
> Key: IGNITE-22866
> URL: https://issues.apache.org/jira/browse/IGNITE-22866
> Project: Ignite
> Issue Type: Improvement
> Components: general, sql
> Affects Versions: 3.0.0-beta2
> Reporter: Igor
> Priority: Major
> Labels: ignite-3
>
> *Description:*
> Need to support recursive queries.
> The query
> {code:java}
> WITH RECURSIVE t(n) AS (SELECT 1 UNION ALL SELECT n + 1 FROM t WHERE n < 100)
> SELECT sum(n) FROM t; {code}
> should return
> {code:java}
> 5050 {code}
> currently returns error
> {code:java}
> Invalid SQL statement type. Expected [DML, DDL] but got QUERY {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
