[
https://issues.apache.org/jira/browse/IGNITE-29043?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18113217#comment-18113217
]
Ignite TC Bot commented on IGNITE-29043:
----------------------------------------
{panel:title=Branch: [pull/13562/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/13562/head] Base: [master] : New Tests
(4)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL 2{color} [[tests
3|https://ci2.ignite.apache.org/viewLog.html?buildId=9334303]]
* {color:#013220}IgniteCalciteTestSuite2:
RecursiveCtePlannerTest.testNestedCteFlags - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite2:
RecursiveCtePlannerTest.testImplicitRecursiveFlags - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite2:
RecursiveCtePlannerTest.testOrdinaryCteFlags - PASSED{color}
{color:#00008b}Calcite SQL 3{color} [[tests
1|https://ci2.ignite.apache.org/viewLog.html?buildId=9335514]]
* {color:#013220}IgniteCalciteTestSuite3:
RecursiveCteIntegrationTest.testOptionalRecursiveKeyword - PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=9334337&buildTypeId=IgniteTests24Java8_RunAll]
{color:#ffffff}tcbot-analysis-comment chainBuildId=9334337
rerunBuildIds=9335546,9335548{color}
> Calcite: Support recursive CTEs without the RECURSIVE keyword
> -------------------------------------------------------------
>
> Key: IGNITE-29043
> URL: https://issues.apache.org/jira/browse/IGNITE-29043
> Project: Ignite
> Issue Type: Improvement
> Reporter: Vladislav Pyatkov
> Assignee: Vladislav Pyatkov
> Priority: Major
> Labels: calcite, ignite-2, sql
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Allow omitting RECURSIVE by detecting CTE self-references after parsing and
> setting the recursive flag before validation. Respect nested CTE scopes and
> identifier casing. Although this syntax is not ANSI SQL compliant, it is a
> valuable usability improvement that simplifies queries and improves
> compatibility with other databases.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
