[
https://issues.apache.org/jira/browse/IGNITE-28739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kirill Tkalenko updated IGNITE-28739:
-------------------------------------
Description:
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]] "[ FETCH
{ FIRST | NEXT } [ count ] \{ ROW | ROWS } ONLY ]", but the proposal is to make
it "[ FETCH \{ FIRST | NEXT }
[ count | (expression) ]
{ ROW | ROWS }
ONLY ]".
was:
By analogy with various DBMS systems such as
[oracle|[https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/SELECT.html]],
[postgresql|[https://www.postgresql.org/docs/18/sql-select.html#SQL-LIMIT]],
and [H2|[https://h2database.com/html/commands.html#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]] "[ FETCH {
FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]", but the proposal is to make it
"[ FETCH { FIRST | NEXT } [ count | (expression) ] { ROW | ROWS } ONLY ]".
> Add expression support for FETCH in the Calcite SQL engine
> ----------------------------------------------------------
>
> 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
>
> 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]] "[ FETCH
> { FIRST | NEXT } [ count ] \{ ROW | ROWS } ONLY ]", but the proposal is to
> make it "[ FETCH \{ FIRST | NEXT }
> [ count | (expression) ]
> { ROW | ROWS }
> ONLY ]".
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
