Kirill Tkalenko created IGNITE-28739:
----------------------------------------
Summary: 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
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 ]".
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
