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)
