Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-24642

REST pages in a space resource empty when ordered by date on Oracle

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 18.7.0-rc-1, 18.4.4, 17.10.12
    • 16.10.0
    • REST
    • None
    • Integration
    • Unknown
    • N/A
    • N/A

    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.

      Attachments

        Activity

          People

            MichaelHamann Michael Hamann
            MichaelHamann Michael Hamann
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: