When deleting an asset library, its ResourcePermission records are not deleted

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.3.X, Master
• Fix Version/s: 7.3.X, 7.4.3.7 CE GA7, 7.4.13 DXP U3, Master
• Component/s: Asset Libraries
• Labels:
  • ee-ts
  • liferay-fixpack-dxp-4-7310
  • liferay-update-dxp-3-7413
  • liferay-update-dxp-4-7310
• Branch Version/s:
  7.3.x
• Backported to Branch:
  Committed
• Story Points: 1
• Fix Priority: 2
• Sprint: LIMA | QA Sprint 17
• Git Pull Request: https://github.com/liferay-lima/liferay-portal/pull/2599

When deleting an asset library, there are some database wrong references, its ResourcePermission records are not deleted

Steps to reproduce

1. Create an asset library
2. Execute the SQL:

   select * from DepotEntry

   to get the DepotEntryId of the created asset library

3. Execute this SQL:

   select * from ResourcePermission where primKeyId = <DepotEntryId>

   ==> this query should return some records

4. Delete the previously created asset library
5. Execute again the SQL of step number 3:
   • Expected behavior: the query doesn't return any record
   • Wrong behavior: the query returns some records