You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by Yanjing Wang <zh...@gmail.com> on 2022/04/06 09:11:48 UTC

[DISCUSS] OFFSET 10 LIMIT 10 VS LIMIT 10 OFFSET 10

Hi Community,
I found Trino supports OFFSET clause appears before LIMIT clause, otherwise
Calcite supports OFFSET clause appears after LIMIT clause.
I want to extract the OFFSET clause as a production rule and put it on the
both before and after LIMIT clause position in an optional way.
How do you think?