You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladislav Pyatkov (Jira)" <ji...@apache.org> on 2026/09/17 10:40:00 UTC
[jira] [Created] (IGNITE-29060) SQL Calcite: Support CYCLE keyword for recursive CTE
Vladislav Pyatkov created IGNITE-29060:
------------------------------------------
Summary: SQL Calcite: Support CYCLE keyword for recursive CTE
Key: IGNITE-29060
URL: https://issues.apache.org/jira/browse/IGNITE-29060
Project: Ignite
Issue Type: Improvement
Reporter: Vladislav Pyatkov
Fix For: 2.19
Call notation:
{code}
WITH [RECURSIVE] cte_name [(column_name, ...)] AS (
initial_query
UNION [ALL | DISTINCT]
recursive_query
)
CYCLE key_column [, ...]
SET cycle_flag TO cycle_value DEFAULT default_value
USING cycle_path
SELECT ...;
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)