Remove LOWER Function from Queries Executed in Non Case Sensitive Databases

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.X EE, 7.0.X, Master
• Fix Version/s: 6.2.X EE, 7.0.0 DXP FP40, 7.0.0 DXP SP7, 7.0.5 CE GA6, 7.0.X, 7.1.X, Master
• Component/s: Performance
• Labels:
  • INACTIVE
  • ee-ts
  • liferay-digital-enterprise-70-sp7
  • liferay-fixpack-de-40-7010
• Branch Version/s:
  7.0.x, 6.2.x
• Backported to Branch:
  Committed
• Story Points: 4
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/55760

Using the LOWER function in queries can decrease performance of their transactions.
Although some databases can be configured as "case insensitive" thus not needing the LOWER function, Liferay still uses the LOWER function in its queries to guarantee the expected result.
The goal of this ticket is to apply the removal of LOWER functions in queries before they are sent to the database, only if this database is configured to not support case sensitiveness.

This is already implemented in Liferay for MySQL, so a improvement of performance will only be noticeable when using other databases.