When deleting a navigation menu, its ResourcePermission records are not deleted

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.3.X, Master
• Fix Version/s: 7.1.10 DXP FP26, 7.1.10.7 SP7, 7.1.X, 7.2.10 DXP FP15, 7.2.X, 7.3.10.3 DXP SP3, 7.3.X, 7.4.13 DXP GA1, 7.4.3.4 CE GA4, Master
• Component/s: Navigation Menus
• Labels:
  • ee-ts
  • liferay-dxp-71-sp7
  • liferay-dxp-73-sp3
  • liferay-fix-pack-dxp-3-7310
  • liferay-fixpack-dxp-15-7210
  • liferay-fixpack-dxp-26-7110
  • liferay-fixpack-dxp-3-7310
• Branch Version/s:
  7.3.x, 7.2.x, 7.1.x
• Backported to Branch:
  Committed
• Fix Priority: 2
• Git Pull Request: https://github.com/liferay-echo/liferay-portal/pull/5798

When deleting a navigation menu, there are some database wrong references

Steps to reproduce

1. Create a navigation menu
2. Execute the SQL:

   select * from SiteNavigationMenu

   to get the SiteNavigationMenuId of the created navigation menu

3. Execute this SQL:

   select * from ResourcePermission where primKeyId = <SiteNavigationMenuId>

   ==> this query should return some records

4. Delete the previously created navigation menu
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