[
https://issues.apache.org/jira/browse/CALCITE-6822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17925837#comment-17925837
]
xiong duan commented on CALCITE-6822:
-------------------------------------
IMO, Postgresql support
OFFSET 10 rows FETCH NEXT 100 ROWS only
Then we don't need to change it in this PR. Please test the other database you
describe in the Summary, If this SQL can run successfully, then we don't need
to change this.
> Write LIMIT for fetch operations in Postgresql/Phoenix/Paraccel/Teradata
> ------------------------------------------------------------------------
>
> Key: CALCITE-6822
> URL: https://issues.apache.org/jira/browse/CALCITE-6822
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.38.0
> Reporter: Yu Xu
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.39.0
>
>
> Postgresql/Phoenix/Paraccel/Teradata support limit and offset syntax, but
> currently would call as: SELECT \"product_id\"\nFROM
> \"foodmart\".\"product\"\nOFFSET 10 ROWS\nFETCH NEXT 100 ROWS ONLY, which not
> consistent with the syntax，need to support it.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
