Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1886

Support "LIMIT [offset,] row_count", per MySQL

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.14.0
    • Component/s: None
    • Labels:
      None

      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}

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                julianhyde Julian Hyde
                Reporter:
                qihanycx Chen Xin Yu
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: