This issue has been created
There is 1 update.
 
 
XWiki Platform / cid:jira-generated-image-avatar-505694b9-268a-416f-9a8d-25cbc2b4e1aa XWIKI-24643 Open

Several REST resources return results in arbitrary, unstable order

 
View issue   ยท   Add comment
 

Issue created

 
cid:jira-generated-image-avatar-31c0c02c-8a17-4c3a-83ca-5382d00d1e6e Michael Hamann created this issue on 30/Jul/26 11:47
 
Summary: Several REST resources return results in arbitrary, unstable order
Issue Type: cid:jira-generated-image-avatar-505694b9-268a-416f-9a8d-25cbc2b4e1aa Bug
Affects Versions: 16.10.0
Assignee: Unassigned
Components: REST
Created: 30/Jul/26 11:47
Priority: cid:jira-generated-image-static-major-5d66d1cd-1503-4dce-aad2-ce264e0c9428 Major
Reporter: Michael Hamann
Description:

Some REST resources return their results in a random, database-defined order instead of a deterministic order.

Affected resources:

  • All pages of a wiki: /rest/wikis/xwiki/pages?number=25&start=0
  • All attachments of a wiki: /rest/wikis/xwiki/attachments?number=25&start=0 
  • Attachments of a space: /rest/wikis/xwiki/spaces/Sandbox/attachments?number=25&start=0
  • Attachments of a page: /rest/wikis/xwiki/spaces/Sandbox/pages/WebHome/attachments?number=25&start=0
  • Pages of a space, ordered by date: /rest/wikis/xwiki/spaces/Sandbox/pages?order=date&number=25&start=0 - ordered by date but there may be same-date documents where the date/time is not unique like from extensions installations.

The actual behavior depends on the database. On some databases, the order might be random but stable, on others, in particular Postgres and possibly Oracle, the order might change even with different pagination offsets, meaning that it is impossible to cleanly paginate over the results. Effects should be more visible with larger result sets (more pages/attachments in a wiki/space/page).

 
 

1 update

 
cid:jira-generated-image-avatar-31c0c02c-8a17-4c3a-83ca-5382d00d1e6e Changes by Michael Hamann on 30/Jul/26 11:47
 
Assignee: Michael Hamann