Searching for layouts with no permissions uses nullable column for not exists check

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.X EE, 7.0.0 DXP SP1, Master
• Fix Version/s: 6.2.X EE, 7.0.0 DXP FP7, 7.0.0 DXP SP1, 7.0.3 CE GA4, 7.1.X, Master
• Component/s: Core Infrastructure, Core Infrastructure > Upgrade Framework
• Labels:
  • QA-CT
  • liferay-digital-enterprise-70-sp1
  • liferay-fixpack-de-7-7010
  • liferay-fixpack-portal-124-6210
• Branch Version/s:
  7.0.x, 6.2.x
• Backported to Branch:
  Committed
• Story Points: 1
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/43907

While this will work in practice because there are no null values (so the database statistics may tell it that there are no null values and optimize accordingly), it may be inefficient if the query optimizer is not aware that it is performing a not-exists style check.