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

Page tree is not sorted by title when using Oracle DB

          Details

          • Type: Bug
          • Status: Closed
          • Priority: Minor
          • Resolution: Fixed
          • Affects Version/s: 11.10.2
          • Fix Version/s: 11.10.11, 12.6.5, 12.10
          • Component/s: Index
          • Environment:
            jetty container with oracle 12c
          • Difficulty:
            Easy
          • Documentation:
            N/A
          • Documentation in Release Notes:
            N/A
          • Pull Request Status:
            Pull Request accepted
          • Similar issues:

            Description

            When giving pages titles different from their page names the pages are still sorted by their name (or the corresponding space name), at least in a single language wiki.

            The reason for this is that in the SQL queries it is checked that doc.XWD_LANGUAGE = '' for the original (non-translated) page, while Oracle seems to store null instead in this field and needs a doc.XWD_LANGUAGE is null check instead.

              Attachments

                Activity

                  People

                  • Assignee:
                    camil7 Clemens Robbenhaar
                    Reporter:
                    camil7 Clemens Robbenhaar
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: