[
https://issues.apache.org/jira/browse/IGNITE-28739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18105461#comment-18105461
]
Ignite TC Bot commented on IGNITE-28739:
----------------------------------------
{panel:title=Branch: [pull/13464/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/13464/head] Base: [master] : New Tests
(26)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL 2{color} [[tests
3|https://ci2.ignite.apache.org/viewLog.html?buildId=9290383]]
* {color:#013220}IgniteCalciteTestSuite2:
LimitOffsetPlannerTest.testFetchExpressionPushDown - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite2:
LimitOffsetPlannerTest.testFetchExpressionFieldTrimmingPreservesCollationTrait
- PASSED{color}
* {color:#013220}IgniteCalciteTestSuite2:
LimitOffsetPlannerTest.testFetchExpressionMinRowCount - PASSED{color}
{color:#00008b}Calcite SQL 3{color} [[tests
23|https://ci2.ignite.apache.org/viewLog.html?buildId=9290384]]
* {color:#013220}IgniteCalciteTestSuite3:
LimitOffsetIntegrationTest.testFetchExpressionWithNvlAndCoalesce[sqlTxMode=ALL]
- PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
LimitOffsetIntegrationTest.testFetchExpressionWithNvlAndCoalesce[sqlTxMode=RANDOM]
- PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
LimitOffsetIntegrationTest.testFetchExpressionWithNvlAndCoalesce[sqlTxMode=NONE]
- PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
DynamicParametersIntegrationTest.testFetchExpressionWithNvlAndCoalesce -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
OperatorsExtensionIntegrationTest.testRowNumRewrite - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
LimitOffsetIntegrationTest.testFetchExpressionWithoutPushDown[sqlTxMode=ALL] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
LimitOffsetIntegrationTest.testInvalidFetchExpression[sqlTxMode=RANDOM] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
LimitOffsetIntegrationTest.testFetchExpressionWithoutPushDown[sqlTxMode=RANDOM]
- PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
LimitOffsetIntegrationTest.testInvalidFetchExpression[sqlTxMode=NONE] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
LimitOffsetIntegrationTest.testFetchExpressionWithoutPushDown[sqlTxMode=NONE] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
LimitOffsetIntegrationTest.testInvalidFetchExpression[sqlTxMode=ALL] -
PASSED{color}
... and 12 new tests
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=9290417&buildTypeId=IgniteTests24Java8_RunAll]
{color:#ffffff}tcbot-analysis-comment chainBuildId=9290417
rerunBuildIds=9291119,9291121,9291123,9291125,9291127{color}
> SQL Calcite: Add expression support for FETCH
> ---------------------------------------------
>
> Key: IGNITE-28739
> URL: https://issues.apache.org/jira/browse/IGNITE-28739
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Kirill Tkalenko
> Assignee: Kirill Tkalenko
> Priority: Major
> Labels: ignite-2
> Time Spent: 6h 40m
> Remaining Estimate: 0h
>
> By analogy with various DBMS systems such as
> [oracle|https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/SELECT.html],
> [postgresql|#SQL-LIMIT], and [H2|#select], it is proposed to add the ability
> to use expressions to FETCH.
> Currently, it's in
> [calcite|https://calcite.incubator.apache.org/docs/reference.html]
> {noformat}
> [ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]{noformat}
> , but the proposal is to make it
> {noformat}
> [ FETCH { FIRST | NEXT } [ count | (expression) ] { ROW | ROWS } ONLY
> ]{noformat}
> .
> I didn't encounter any objections from the community on [dev
> list|https://lists.apache.org/thread/2nq9y7l2pc2owv56nkd40gohvholbq87] (Add
> expression for FETCH FIRST | NEXT rows only in Calcite SQL Engine).
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
