ResourceBlockPermission table grows with orphan rows

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.3 CE GA4, 6.2.10 EE GA1, 6.2.X EE, 7.0.0 M5, 7.0.0 DXP SP1, Master
• Fix Version/s: 7.0.0 DXP FP28, 7.0.X EE, 7.0.4 CE GA5, 7.1.X, Master
• Component/s: Application Security > Permissions
• Labels:
  • QA-V
  • ee-ts
  • liferay-digital-enterprise-70-sp5
  • liferay-fixpack-de-26-7010
  • liferay-fixpack-de-28-7010
  • security-filter-bugs
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Story Points: 1
• Fix Priority: 4
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/50454

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.