[jira] [Created] (CALCITE-5184) In parser, allow "LIMIT start, ALL"

["Julian Hyde (Jira)" <ji...@apache.org>]

Julian Hyde created CALCITE-5184:
------------------------------------

             Summary: In parser, allow "LIMIT start, ALL"
                 Key: CALCITE-5184
                 URL: https://issues.apache.org/jira/browse/CALCITE-5184
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde


In parser, allow "LIMIT start, ALL". For example,
{code:sql}
SELECT *
FROM Emp
ORDER BY sal DESC
LIMIT 10, ALL
{code}
would be equivalent to
{code:sql}
SELECT *
FROM Emp
ORDER BY sal DESC
OFFSET 10
{code}

No other database supports this syntax, but Calcite supports Postgres' "LIMIT ALL" and MySQL's "LIMIT start, count" so it makes sense to combine them.

See the original discussion in CALCITE-5086.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)