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)