[CALCITE-5184] In parser, allow "LIMIT start, ALL"

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.36.0
• Labels: pull-request-available
• Assignee: hongyu guo
• Reporter: Julian Hyde
• Created: 06/Jun/22 22:31
• Updated: 10/Nov/23 11:34
• Resolved: 12/Aug/23 00:50

Description

In parser, allow "LIMIT start, ALL". For example,

SELECT *
FROM Emp
ORDER BY sal DESC
LIMIT 10, ALL

would be equivalent to

SELECT *
FROM Emp
ORDER BY sal DESC
OFFSET 10

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.

Issue Links

• is related to: CALCITE-1886 Support "LIMIT [offset,] row_count", per MySQL
• relates to: CALCITE-5086 Core parser should allow "OFFSET" to occur before "LIMIT"
• links to: GitHub Pull Request #3352