DataNucleus JIRA is now in read-only mode. Raise any new issues in GitHub against the plugin that it applies to. DataNucleus JIRA will remain for the foreseeable future but will eventually be discontinued
Issue Details (XML | Word | Printable)

Key: NUCRDBMS-732
Type: Task Task
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Unassigned
Reporter: Andy Jefferson
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

Add support for range offset/limit with Derby using OFFSET/FETCH keywords

Created: 30/Dec/13 09:35 AM   Updated: 06/Jan/14 11:19 AM   Resolved: 30/Dec/13 09:40 AM
Component/s: Code Structure
Affects Version/s: None
Fix Version/s: 3.2.10


 Description  « Hide
Derby 10.5+ has

[ OFFSET integer-literal {ROW | ROWS} ]
[ FETCH { FIRST | NEXT } [integer-literal] {ROW | ROWS} ONLY ]

Andy Jefferson added a comment - 30/Dec/13 09:40 AM
GitHub master supports this now

Andy Jefferson made changes - 30/Dec/13 09:40 AM
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.2.10 [ 12061 ]
Resolution Fixed [ 1 ]
Andy Jefferson made changes - 06/Jan/14 11:19 AM
Status Resolved [ 5 ] Closed [ 6 ]