Web Content friendly URLs with special characters are not validated correctly against duplicates

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.1.X, Master
• Fix Version/s: 7.1.10 DXP FP9, 7.1.10.2 SP2, 7.1.3 CE GA4, 7.1.X, Master
• Component/s: Content Publishing > Staging, WCM
• Labels:
  • QA-AUTOMATION
  • ee-ts
  • liferay-dxp-71-sp2
  • liferay-fixpack-dxp-9-7110
  • qa_test_mapped
• Branch Version/s:
  7.1.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/67477

Reproduction steps:

1. Start a master bundle
2. Create a new site
3. Create a new web content with a special character in the title. E.g.: "Special Char aŐb"
4. Make sure that the saved friendly URL of this content is "special-char-aŐb" in DB it will be "special-char-a%C5%90b"
5. Create a second web content (title can be anything), set its friendly URL to "special-char-a-c5-90b" (every special character of the encoded string replaced with "-")
6. Turn on local staging

Expected: Local stating activated successfully.
Actual: Initial publication fails, DuplicateFriendlyURLEntryException in the logs:

2019-01-14 14:43:02.379 ERROR [liferay/background_task-1][BackgroundTaskMessageListener:173] Unable to execute background task
com.liferay.exportimport.kernel.lar.PortletDataException: {mvccVersion=0, friendlyURLEntryLocalizationId=6, companyId=20099, friendlyURLEntryId=37081, languageId=en_US, urlTitle=special-char-a-c5-90b, groupId=37052, classNameId=20501, classPK=37077}
...
Caused by: com.liferay.friendly.url.exception.DuplicateFriendlyURLEntryException: {mvccVersion=0, friendlyURLEntryLocalizationId=6, companyId=20099, friendlyURLEntryId=37081, languageId=en_US, urlTitle=special-char-a-c5-90b, groupId=37052, classNameId=20501, classPK=37077}