[
https://issues.apache.org/jira/browse/IGNITE-14777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18095025#comment-18095025
]
Ignite TC Bot commented on IGNITE-14777:
----------------------------------------
{panel:title=Branch: [pull/12096/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/12096/head] Base: [master] : New Tests
(144)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL 3{color} [[tests
31|https://ci2.ignite.apache.org/viewLog.html?buildId=9185868]]
* {color:#013220}IgniteCalciteTestSuite3:
StdSqlOperatorsTest.testWindowFunctions - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
WindowIntegrationTest.testLeadLagFunctions[sqlTxMode=ALL] - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
WindowIntegrationTest.testCountAllRange[sqlTxMode=ALL] - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
WindowIntegrationTest.testCountRowsPartitioned[sqlTxMode=ALL] - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
WindowIntegrationTest.testCountRangePartitionedWithIntBounds[sqlTxMode=ALL] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
WindowIntegrationTest.testCountRowsPartitionedWithBounds[sqlTxMode=ALL] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
WindowIntegrationTest.testAggregateWithWindowFunction[sqlTxMode=ALL] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
WindowIntegrationTest.testCorrelation[sqlTxMode=ALL] - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
WindowIntegrationTest.testAggregateWithWindowFunction[sqlTxMode=RANDOM] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
WindowIntegrationTest.testCorrelation[sqlTxMode=RANDOM] - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
WindowIntegrationTest.testCountRangePartitionedWithDateBounds[sqlTxMode=RANDOM]
- PASSED{color}
... and 20 new tests
{color:#00008b}Calcite SQL 2{color} [[tests
113|https://ci2.ignite.apache.org/viewLog.html?buildId=9185867]]
* {color:#013220}IgniteCalciteTestSuite2:
WindowPlannerTest.testConstantsInPartitionByAndOrderBy - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite2:
WindowPlannerTest.testIndexedTableAndWindow - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite2:
WindowPlannerTest.testProjectWindowConstantsUnusedInAggCalls - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite2:
WindowPlannerTest.testCorrelatedDistribution - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite2:
WindowPlannerTest.testPassThroughOrderByWithWindow - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite2:
WindowPlannerTest.testHashTableAndWindowWithAnotherDistribution - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite2:
WindowPlannerTest.testHashTableDistributionAndWindow - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite2:
WindowPlannerTest.testProjectWindowConstantsUsedInAggCalls - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite2:
WindowPlannerTest.testSplitWindowRelsByGroup - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite2:
WindowExecutionTest.testLastValue[Task executor = STRIPED, Execution strategy =
FIFO] - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite2:
WindowExecutionTest.testCountRowsBetweenUnboundedPrescendingAndCurrentRow[Task
executor = STRIPED, Execution strategy = FIFO] - PASSED{color}
... and 102 new tests
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=9187477&buildTypeId=IgniteTests24Java8_RunAll]
{color:#ffffff}tcbot-analysis-comment chainBuildId=9187477
rerunBuildIds=none{color}
> Calcite engine. Implement window functions
> ------------------------------------------
>
> Key: IGNITE-14777
> URL: https://issues.apache.org/jira/browse/IGNITE-14777
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Evgeny Stanilovsky
> Assignee: Oleg Zinoviev
> Priority: Major
> Labels: calcite, calcite2-required, calcite3-required, ise
> Time Spent: 16h 50m
> Remaining Estimate: 0h
>
> Window functions are not supported for now.
> examples:
> {noformat}
> SELECT i, j, row_number() OVER (PARTITION BY i ORDER BY j NULLS FIRST) FROM
> test ORDER BY i NULLS FIRST, j NULLS FIRST;
> ---
> SELECT i, (SELECT row_number() OVER (ORDER BY i) FROM integers WHERE i1.i=i)
> FROM integers i1 ORDER BY i;
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
