RegionLocalization records are not deleted after deleting a instance

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: Master
• Fix Version/s: 7.0.0 DXP FP102, 7.0.10.16 DXP SP17, 7.0.X, 7.1.10 DXP FP26, 7.1.10.7 SP7, 7.1.X, 7.2.10 DXP FP15, 7.2.X, 7.3.X, 7.4.13 DXP GA1, Master
• Component/s: Core Infrastructure
• Labels:
  • liferay-dxp-70-sp17
  • liferay-dxp-71-sp7
  • liferay-fixpack-de-102-7010
  • liferay-fixpack-dxp-15-7210
  • liferay-fixpack-dxp-26-7110
• Branch Version/s:
  7.3.x, 7.2.x, 7.1.x, 7.0.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/106626

Database wrong references

Steps to reproduce

1. Go to Control Panel => Virtual instances
2. Create a new instance
3. Once the instance is completely created, delete it
4. Execute this SQL:

   select * from RegionLocalization where companyId not in (select companyId from Company)

– Expected result: the SQL doesn't return any record
– Wrong result: the SQL returns Japanese records