Details
-
New Feature
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
None
-
None
-
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, jamestaylor
Attachments
Attachments
There are no Sub-Tasks for this issue.