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

ResourceBlockPermission table grows with orphan rows

    Details

      Description

      ResourceBlockPermission table grows with orphan rows.

      This can be tested example:
      1. Empty Liferay installation
      2. Insert 3 teams to default site.
      3. Insert 5 Bookmarks
      4. Give multiple permissions to these teams. So that you check multiple teams with same time. See: Screen Shot 2015-04-28 at 2010.50.16.png
      5. You expect to see 0 from following query:

      select count(*) from ResourceBlockPermission where resourceBlockId not in (select resourceBlockId from ResourceBlock);
      

      But you see larger than 0.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              linda.sui Linda Sui
              Reporter:
              sampsa.sohlman Sampsa Sohlman (Inactive)
              Participants of an Issue:
              Recent user:
              Csaba Turcsan
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                3 years, 18 weeks ago

                  Packages

                  Version Package
                  7.0.0 DXP FP28
                  7.0.X EE
                  7.0.4 CE GA5
                  7.1.X
                  Master