This issue has been created
There is 1 update.
 
 
XWiki Platform / cid:jira-generated-image-avatar-8e4db8ea-b686-44f5-a86c-9622bb9eff25 XWIKI-24642 Open

REST pages in a space resource empty when ordered by date on Oracle
 
View issue   ยท   Add comment
 

Issue created

 
cid:jira-generated-image-avatar-0e2b66d7-8d5c-45d1-aa53-7374e63834d8 Michael Hamann created this issue on 30/Jul/26 10:55
 
Summary: REST pages in a space resource empty when ordered by date on Oracle
Issue Type: cid:jira-generated-image-avatar-8e4db8ea-b686-44f5-a86c-9622bb9eff25 Bug
Affects Versions: 16.10.0
Assignee: Unassigned
Components: REST
Created: 30/Jul/26 10:55
Priority: cid:jira-generated-image-static-major-1c8cc47b-c5b3-4a5b-91cf-12d9b1b870b2 Major
Reporter: Michael Hamann
Description:

Steps to reproduce:

Open /xwiki/rest/wikis/xwiki/spaces/Main/pages?order=date on an instance that uses Oracle as database

Expected result:

The result is non-empty.

Actual result:

The result is empty.

This is because the query matches on language = '' which is not working on Oracle because the empty string is stored as NULL.
 
 

1 update

 
cid:jira-generated-image-avatar-0e2b66d7-8d5c-45d1-aa53-7374e63834d8 Changes by Michael Hamann on 30/Jul/26 10:55
 
Assignee: Michael Hamann
 
 
This message was sent by Atlassian Jira (v9.3.0#930000-sha1:287aeb6) Atlassian logo
If image attachments aren't displayed, see this article.