You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ignite TC Bot (Jira)" <ji...@apache.org> on 2026/09/09 07:48:00 UTC
[jira] [Commented] (IGNITE-29012) Support recursive CTE with UNION DISTINCT
[ https://issues.apache.org/jira/browse/IGNITE-29012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18113194#comment-18113194 ]
Ignite TC Bot commented on IGNITE-29012:
----------------------------------------
{panel:title=Branch: [pull/13563/head] Base: [master] : No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/13563/head] Base: [master] : New Tests (4)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL 2{color} [[tests 1|https://ci2.ignite.apache.org/viewLog.html?buildId=9334155]]
* {color:#013220}IgniteCalciteTestSuite2: RecursiveCtePlannerTest.testRecursiveDistinctPlan - PASSED{color}
{color:#00008b}Calcite SQL 3{color} [[tests 3|https://ci2.ignite.apache.org/viewLog.html?buildId=9334156]]
* {color:#013220}IgniteCalciteTestSuite3: RecursiveCteIntegrationTest.testRecursiveDistinctLargeDuplicateBatch - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3: RecursiveCteIntegrationTest.testRecursiveCteWithDistinctUnion - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3: RecursiveCteIntegrationTest.testRecursiveDistinctNulls - PASSED{color}
{panel}
[TeamCity *--> Run :: All* Results|https://ci2.ignite.apache.org/viewLog.html?buildId=9334189&buildTypeId=IgniteTests24Java8_RunAll]
{color:#ffffff}tcbot-analysis-comment chainBuildId=9334189 rerunBuildIds=9335496,9335498,9335500,9335502{color}
> 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
> Time Spent: 10m
> 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)