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

In Group_ table, null values in type_ column causes Liferay to be unable to add index on friendlyURL column

    Details

      Description

      The finder query for GroupFinder.findByNullFriendlyURL will only return those values where the type_ field is not null.

      However, because type_ is a nullable column, it is possible to not specify a value for type_ (and Liferay does so in portal-data-sample.vm in 5.1.x), resulting in null values in the database. When multiple null values are present, Liferay will be unable to add an index on Group_ (companyId, friendlyURL) because it would not have updated the friendlyURL on those groups.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              brian.chan Brian Chan
              Reporter:
              minhchau.dang Minhchau Dang
              Participants of an Issue:
              Recent user:
              Marta Elicegui
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                9 years, 6 weeks, 3 days ago

                  Packages

                  Version Package
                  6.1.10 EE GA1
                  6.1.20 EE GA2
                  6.2.0 CE M2