Type: New Feature
Affects Version/s: None
Fix Version/s: 4.8.0
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.
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 Taylor
|Document Offset and Fetch SQL construct||Closed|