[SOLR-15489] Solr SQL should respect OFFSET and FETCH criteria when used with ORDER BY

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 9.0, 8.10
• Component/s: Parallel SQL
• Labels: RobustSQL
• Assignee: Timothy Potter
• Reporter: Timothy Potter
• Created: 21/Jun/21 18:09
• Updated: 28/Sep/21 20:23
• Resolved: 29/Jun/21 23:20

Description

Tried a simple example over a collection containing 11 docs with id's (1-11)

SELECT id FROM $ALIAS ORDER BY id DESC OFFSET 5 FETCH NEXT 5 ROWS ONLY

Got back the first page (11,10,9,8,7) vs. the second (6,5,4,3,2), i.e. it's just doing LIMIT 5 with offset 0 vs. respecting the FETCH with OFFSET.

From the Calcite grammar:

[ ORDER BY orderItem [, orderItem ]* ]
      [ LIMIT [ start, ] { count | ALL } ]
      [ OFFSET start { ROW | ROWS } ]
      [ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]

Issue Links

• links to: GitHub Pull Request #191
• links to: GitHub Pull Request #2526