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)