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

              linda.sui Linda Sui
              minhchau.dang Minhchau Dang
              Kiyoshi Lee Kiyoshi Lee
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                6 years, 32 weeks, 2 days 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