[jira] [Created] (IGNITE-28739) Add expression support for FETCH in the Calcite SQL engine

["Kirill Tkalenko (Jira)" <ji...@apache.org>]

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)