Duplicate category in UpgradeJournalArticleType when database case sensitive

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X, 7.1.X, 7.2.X, Master
• Fix Version/s: 7.0.10.13 DXP SP13, 7.0.X, 7.1.X, 7.2.10 DXP FP5, 7.2.10.2 DXP SP2, 7.2.X, 7.3.1 CE GA2, 7.3.2 CE GA3, 7.3.10 DXP GA1, Master
• Component/s: WCM
• Labels:
  • ee-ts
  • liferay-dxp-70-sp13
  • liferay-dxp-72-sp2
  • liferay-fixpack-de-90-7010
  • liferay-fixpack-dxp-17-7110
  • liferay-fixpack-dxp-5-7210
  • pt-upgrade-review
• Branch Version/s:
  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/83852

Steps to Reproduce:

1. Create a database with a case sensitive collation, for example utf8_bin
2. In a 6.2 add the following property:

   journal.article.types=blogs,Blogs
   

1. Start the portal.
2. Create an article, choosing in Categorization the first "Blogs" entry as article type.
3. Create a second article, choosing in Categorization the second "Blogs" entry as article type.
4. Perform an upgrade.

 

Expected Results:

The upgrade should finish without exception.

 

Actual Results:

The upgrade finishes with an exception like the following one:

Caused by: com.liferay.asset.kernel.exception.DuplicateCategoryException: There is another category named blogs as a child of category 0