Igor created IGNITE-22866:
-----------------------------
Summary: 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
*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)
