[CALCITE-5086] Core parser should allow "OFFSET" to occur before "LIMIT"

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.30.0
• Fix Version/s: 1.31.0
• Component/s: core
• Labels: pull-request-available

Environment

jdk8

• Assignee: yanjing.wang
• Reporter: yanjing.wang
• Created: 07/Apr/22 10:01
• Updated: 03/Aug/22 16:21
• Resolved: 06/Jun/22 22:16

Description

The core parser supports 'LIMIT count OFFSET start' now, otherwise trino supports 'OFFSET start LIMIT count', we can make an improvement to support both.

Issue Links

• is related to: CALCITE-5184 In parser, allow "LIMIT start, ALL"
• relates to: CALCITE-1886 Support "LIMIT [offset,] row_count", per MySQL
• links to: GitHub Pull Request #2768