[jira] [Updated] (IGNITE-28739) SQL Calcite: Add expression support for FETCH

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

     [ https://issues.apache.org/jira/browse/IGNITE-28739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kirill Tkalenko updated IGNITE-28739:
-------------------------------------
    Summary: SQL Calcite: Add expression support for FETCH  (was: Add expression support for FETCH in the Calcite SQL engine)

> 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: 10m
>  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)