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

Sorting of values in page and DB list picker depends on the database

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 18.6.0-rc-1
    • 16.10.0
    • Old Core
    • None
    • Unit, Integration
    • Unknown
    • N/A
    • N/A

    Description

      Steps to reproduce:

      1. Create a page/space SortDemo
      2. Within that space, create three pages in that order:
        1. Title: "Sortcheck Mango", name: "aaa"
        2. Title: "Sortcheck Apple", name: "mmm"
        3. Title: "Sortcheck Zebra", name: "zzz"
      3. Go to "Application Within Minutes" and start creating an application.
      4. Enter any name like "SortcheckApp" and continue to the next step.
      5. Add a "Page" field. In the preview, type "Sortcheck" and check the order of the suggestions:

      Expected result:

      The suggestions are displayed in alphabetic order, independent of the database. Note: the order is also modified in the UI based on the match. The page titles are chosen to be of the same length to have the same match score, in which case the order from the server is used.

      Actual result:

      The suggestions are displayed in a different order, that also varies depending on the database (according to CI results, it should be different on MariaDB/MySQL vs. the other databases.

      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: