[
https://issues.apache.org/jira/browse/IGNITE-29041?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18111631#comment-18111631
]
Ignite TC Bot commented on IGNITE-29041:
----------------------------------------
A local documentation patch has been prepared for this issue, but I could not
publish the branch from the current automation environment. GitHub rejected
push to https://github.com/ignitetcbot/ignite.git with 403: Permission to
ignitetcbot/ignite.git denied to ignitetcbot.\n\nLocal patch summary:\n*
docs/_docs/SQL/sql-calcite.adoc: add a Recursive CTEs section for WITH
RECURSIVE + UNION ALL, limits, memory quota note, and
sql.calcite.recursiveCteIterationLimit.\n*
docs/_docs/sql-reference/sql-conformance.adoc: replace the stale statement that
recursive WITH fails in Ignite with a Calcite-specific reference.\n\nLocal
branch/commit in the automation checkout: IGNITE-29041-docs / e9ff8d2f9c. A
maintainer needs to publish the branch or grant the bot fork push permission
before a PR can be opened.
> [doc] Document recursive CTE support in Calcite SQL engine
> ----------------------------------------------------------
>
> Key: IGNITE-29041
> URL: https://issues.apache.org/jira/browse/IGNITE-29041
> Project: Ignite
> Issue Type: Task
> Components: documentation
> Reporter: Ignite TC Bot
> Priority: Major
> Labels: ignite-2
> Fix For: 2.19
>
>
> Document Apache Ignite 2 Calcite SQL recursive CTE support added by
> IGNITE-27822 / PR https://github.com/apache/ignite/pull/13479.
> The docs should cover:
> * WITH RECURSIVE support in the Calcite-based SQL engine;
> * supported UNION ALL recursive CTE shape, including hierarchy traversal /
> sequence-style examples;
> * the current limitation that UNION DISTINCT is not supported yet;
> * recursive CTE execution is coordinator-side for the recursive delta and is
> accounted by Calcite query memory quotas;
> * the distributed property sql.calcite.recursiveCteIterationLimit, default
> 100, and that a negative value disables the limit.
> Suggested pages:
> * docs/_docs/SQL/sql-calcite.adoc for usage, limits, and property details;
> * docs/_docs/sql-reference/sql-conformance.adoc to remove or narrow the stale
> statement that recursive WITH fails in Ignite.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
