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)
