Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-2722

support mysql "limit,offset" clauses

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.8.0
    • Labels:
      None

      Description

      For serial query(query with “serial" hint or “limit" without "order by”), we can limit each scan(using page filter) to “limit+offset” instead of limit earlier.
      And then, for all queries, we can forward the relevant client iterators to the offset provided and then return the result.

      syntax

      [ LIMIT { count } ]
          [ OFFSET start [ ROW | ROWS ] ]
          [ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]
      

      Some new keywords(OFFSET,FETCH,ROW, ROWS,ONLY) are getting introduced so users might need to see that they are not using them as column name or something.

      WDYT, James R. Taylor

        Attachments

        1. PHOENIX-2722.patch
          200 kB
          Ankit Singhal
        2. PHOENIX-2722_v1_rebased.patch
          188 kB
          Ankit Singhal
        3. PHOENIX-2722_formatted.patch
          161 kB
          Ankit Singhal

          Activity

            People

            • Assignee:
              ankit.singhal Ankit Singhal
              Reporter:
              ankit.singhal Ankit Singhal
            • Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: