Missing index by companyId, articlePK in JournalArticleLocalization after LPS-121714

• Type: Regression Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X, 7.1.X, 7.2.X, 7.3.X, Master
• Fix Version/s: Master
• Component/s: Performance, Web Content > Web Content Administration
• Labels:
  • pt-upgrade-review
• Fix Priority: 3
• Git Pull Request: https://github.com/liferay-echo/liferay-portal/pull/3363

After LPS-121714 JournalArticleLocalization indexes including companyId have been removed. They are useful for queries used in modules/apps/journal/journal-service/src/main/resources/META-INF/custom-sql/default.xml

Steps to Reproduce:

1. Start the portal.
2. Check JournalArticleLocalization table indexes.

 

Expected Results:

At least an index based on companyId-articlePK should exist.

 

Actual Results:

No index base on companyId-articlePK exists.