[CALCITE-1886] Support "LIMIT [offset,] row_count", per MySQL

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.14.0
• Assignee: Julian Hyde
• Reporter: Chen Xin Yu
• Created: 12/Jul/17 05:28
• Updated: 06/Jun/22 22:32
• Resolved: 18/Jul/17 18:04

Description

CALCITE support limit offset SQL grammar in CALCITE-43:

  [LIMIT { count | ALL}]
  [OFFSET start { ROW | ROWS}]

Also

LIMIT {[offset,] row_count}

is popular used, especially in MySQL, such as:

select * from tableA order by id limit 100,10;

User should transform the existing SQLs until calcite support

 LIMIT {[offset,] row_count}

Issue Links

• is related to: CALCITE-5086 Core parser should allow "OFFSET" to occur before "LIMIT"
• relates to: CALCITE-43 Support LIMIT, OFFSET, FETCH clauses
• relates to: CALCITE-1893 Add MYSQL_5 conformance
• relates to: CALCITE-5184 In parser, allow "LIMIT start, ALL"