Items are sorted differently depending on database

• Type: Bug
• Status: Verified
• Resolution: Unresolved
• Affects Version/s: 7.2.X, Master
• Fix Version/s: None
• Component/s: User Management > Users & Organizations
• Labels:
  • sme-should-7.3
• Fix Priority: 3

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".