[
https://issues.apache.org/jira/browse/IGNITE-29060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18133586#comment-18133586
]
Ignite TC Bot commented on IGNITE-29060:
----------------------------------------
{panel:title=Branch: [pull/13761/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/13761/head] Base: [master] : New Tests
(86)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL 3{color} [[tests
54|https://ci2.ignite.apache.org/viewLog.html?buildId=9449015]]
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.integration.CycleIntegrationTest.testInvalidMark(String)[10]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.integration.CycleIntegrationTest.testInvalidMark(String)[9]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.integration.CycleIntegrationTest.testInvalidMark(String)[8]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.integration.CycleIntegrationTest.testInvalidMark(String)[7]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.integration.CycleIntegrationTest.testInvalidMark(String)[14]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.integration.CycleIntegrationTest.testInvalidMark(String)[13]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.integration.CycleIntegrationTest.testInvalidMark(String)[12]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.integration.CycleIntegrationTest.testInvalidMark(String)[11]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.integration.CycleIntegrationTest.testInvalidMark(String)[2]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.integration.CycleIntegrationTest.testInvalidMark(String)[1]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.integration.CycleIntegrationTest.testDatePath
- PASSED{color}
... and 43 new tests
{color:#00008b}Calcite SQL 2{color} [[tests
20|https://ci2.ignite.apache.org/viewLog.html?buildId=9449014]]
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.CyclePlannerTest.testGeneratedColumnsNotVisible(String)[2]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.CyclePlannerTest.testGeneratedColumnsNotVisible(String)[1]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.CyclePlannerTest.testNestedRecursiveReference
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.CyclePlannerTest.testRequiresRecursiveUnion
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.CyclePlannerTest.testInvalidReference(String)[2]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.CyclePlannerTest.testInvalidReference(String)[1]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.CyclePlannerTest.testInvalidRecursiveSelect(String)[3]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.CyclePlannerTest.testInvalidRecursiveSelect(String)[2]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.CyclePlannerTest.CyclePlannerTest
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.CyclePlannerTest.testPathType(String)[2]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.planner.CyclePlannerTest.testPathType(String)[1]
- PASSED{color}
... and 9 new tests
{color:#00008b}Calcite SQL 1{color} [[tests
12|https://ci2.ignite.apache.org/viewLog.html?buildId=9448933]]
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.sql.SqlCycleParserTest.testDefaultMarks
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.sql.SqlCycleParserTest.testIncompleteClause(String)[6]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.sql.SqlCycleParserTest.testIncompleteClause(String)[5]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.sql.SqlCycleParserTest.testIncompleteClause(String)[4]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.sql.SqlCycleParserTest.SqlCycleParserTest
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.sql.SqlCycleParserTest.testRoundTrip(String)[3]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.sql.SqlCycleParserTest.testRoundTrip(String)[2]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.sql.SqlCycleParserTest.testRoundTrip(String)[1]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.sql.SqlCycleParserTest.testIncompleteClause(String)[3]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.sql.SqlCycleParserTest.testIncompleteClause(String)[2]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.sql.SqlCycleParserTest.testIncompleteClause(String)[1]
- PASSED{color}
... and 1 new tests
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=9449050&buildTypeId=IgniteTests24Java8_RunAll]
{color:#ffffff}tcbot-analysis-comment chainBuildId=9449050
rerunBuildIds=9449316{color}
> 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
> Assignee: Vladislav Pyatkov
> Priority: Major
> Labels: calcite, ignite-2, sql
> Fix For: 2.19
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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
(v10.3.26#10030026)
