Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-116544

Items are sorted differently depending on database

    Details

    • Type: Bug
    • Status: Verified
    • Resolution: Unresolved
    • Affects Version/s: 7.2.X, Master
    • Fix Version/s: None
    • Component/s: User Management
    • Labels:
    • Fix Priority:
      3

      Description

      Items are sorted differently depending on database. In some cases the case of the sort is ignored, in others it is considered.

      Reproduction Steps:

      1. Add indexer.enabled[com.liferay.portal.kernel.model.Organization]=false to portal-ext.properties
      2. Configure bundle to connect to a MySQL database
      3. Start portal
      4. Go to Control Panel -> Users & Organizations -> Organizations
      5. Add the following organizations, "a", "B", "c", "Org 1", "org 2", and "Org 3".
      6. View the Organizations tab and make sure it's Order by Name.
      7. The results ordering should be "a", "B", "c", "Org 1", "org 2", "Org 3", also shown in attachments. This is also the ordering when the indexer is not disabled.
      8. Stop portal and remove the configuration to the MySQL database so that Hypersonic will be used.
      9. Start portal
      10. Go to Control Panel -> Users & Organizations -> Organizations
      11. Add the following organizations, "a", "B", "c", "Org 1", "org 2", and "Org 3".
      12. View the Organizations tab and make sure it's Order by Name.

      Expected Results: Ordering should be "a", "B", "c", "Org 1", "org 2", "Org 3"
      Actual Results: Ordering is case sensitive "B", "Org 1", "Org 3", "a", "c", "org 2".

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              support-lep@liferay.com SE Support
              Reporter:
              joshua.cords Joshua Cords
              Participants of an Issue:
              Recent user:
              Annie Wu
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Days since last comment:
                15 weeks ago

                  Packages

                  Version Package