[
https://issues.apache.org/jira/browse/IGNITE-29012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18113895#comment-18113895
]
Ignite TC Bot commented on IGNITE-29012:
----------------------------------------
Docs Required was reviewed against PR
https://github.com/apache/ignite/pull/13563 and the local Ignite 2 checkout.
The change adds user-facing recursive CTE support for UNION DISTINCT / UNION,
including duplicate elimination across iterations. This should be covered by
the existing recursive CTE documentation follow-up IGNITE-29041 / PR
https://github.com/apache/ignite/pull/13556. Keeping Docs Required on this
source issue until that docs PR is updated and merged.
> SQL Calcite: Support recursive CTE with UNION DISTINCT
> ------------------------------------------------------
>
> Key: IGNITE-29012
> URL: https://issues.apache.org/jira/browse/IGNITE-29012
> Project: Ignite
> Issue Type: Improvement
> Reporter: Vladislav Pyatkov
> Assignee: Vladislav Pyatkov
> Priority: Major
> Labels: calcite, ignite-2, sql
> Fix For: 2.19
>
> Time Spent: 1h 20m
> Remaining Estimate: 0h
>
> h3.Motivation
> Recursive CTE currently supports only UNION ALL. UNION DISTINCT is required
> to remove previously produced rows during every iteration and to terminate
> cyclic recursive queries.
> h3.Definition of done
> - UNION DISTINCT recursive CTE is supported.
> - Duplicates are removed within and across iterations.
> - Seen-set memory is included in query memory tracking.
> - Cyclic, duplicate, and memory-quota tests are added.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
