CalEvent classNameId entries remain in Subscription table

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X, 7.1.X, 7.2.X, Master
• Fix Version/s: 7.1.10 DXP FP20, 7.1.10.5 SP5, 7.1.X, 7.2.X, 7.3.10 DXP FP1, 7.3.10.1 DXP SP1, 7.3.6 CE GA7, 7.3.X, 7.4.13 DXP GA1, Master
• Component/s: Calendar > Upgrade
• Labels:
  • ee-ts
  • liferay-dxp-71-sp5
  • liferay-dxp-73-sp1
  • liferay-fixpack-dxp-1-7310
  • liferay-fixpack-dxp-20-7110
  • liferay-fixpack-dxp-9-7210
  • pt-upgrade-review
  • qa_automation_ticket_not_needed
  • qa_test_not_needed
• Branch Version/s:
  7.3.x, 7.2.x, 7.1.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/achaparro/liferay-portal/pull/746

Steps to Reproduce:

1. In a 6.1 portal create a Calendar Event
2. Open the created Calendar Event (just click on its link, do not edit it) and subscribe to its comments
3. Execute the following query and save the classNameId returned that will be used for future queries:

   • select classNameId from ClassName_ where value like 'com.liferay.portlet.calendar.model.CalEvent'

1. Ensure, with the following query, that there are records in the table:

   • select * from Subscription where classNameId in (select classNameId from ClassName_ where value like 'com.liferay.portlet.calendar.model.CalEvent');

1. Upgrade to 6.2
2. Ensure, with the following query, that there are records in the table:

   • select * from Subscription where classNameId in (select classNameId from ClassName_ where value like 'com.liferay.portlet.calendar.model.CalEvent');

1. Upgrade to master.
2. Check if there are still old CalEvent classNameId records in Subscription with the following query:

   • select * from Subscription where classNameId = <classNameId>

     For the <classNameId> use the one returned in step 4.

 
Expected Results:

No records with old CalEvent classNameId should remain in Subscription table.

Actual Results:

Records with old CalEvent classNameId remain in Subscription table.