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

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

    Details

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  2 years, 51 weeks, 1 day ago

                  Packages

                  Version Package
                  6.2.X EE
                  7.0.0 DXP FP7
                  7.0.0 DXP SP1
                  7.0.3 CE GA4
                  7.1.X
                  Master