[PHOENIX-2722] support mysql "limit,offset" clauses

• Type: New Feature
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.8.0
• Assignee: Ankit Singhal
• Reporter: Ankit Singhal
• Created: 29/Feb/16 07:06
• Updated: 17/Aug/16 14:46
• Resolved: 08/Apr/16 19:14

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, jamestaylor

Sub-Tasks

• Document Offset and Fetch SQL construct: Closed