When deleting a redirection, 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, 7.4.3.8 CE GA8, 7.4.13 DXP U4, Master
• Component/s: SEO Tools > URL Redirections
• Labels:
  • 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: 3
• Fix Priority: 2
• Sprint: LIMA | QA Sprint 17
• Git Pull Request: https://github.com/liferay-lima/liferay-portal/pull/2603
• Bug Type: Default
• QA Test Name:
  • dont-test-again

When deleting a redirection, there are some database wrong references, its ResourcePermission records are not deleted

Steps to reproduce

1. Go to Site => Configuration => Redirection
2. Create a new Redirect
3. Execute the SQL:

   select * from RedirectEntry

   to get the RedirectEntryd of the created redirect

4. Execute this SQL:

   select * from ResourcePermission where primKeyId = <RedirectEntryId>

   ==> this query should return some records

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