In Group_ table, null values in type_ column causes Liferay to be unable to add index on friendlyURL column

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.1.10 EE GA1, 6.2.0 CE M2
• Fix Version/s: 6.1.10 EE GA1, 6.1.20 EE GA2, 6.2.0 CE M2
• Component/s: Core Infrastructure
• Labels: None
• Branch Version/s:
  6.1.x
• Backported to Branch:
  Committed
• Added to Fix Pack:
  Added
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/4372

The finder query for GroupFinder.findByNullFriendlyURL will only return those values where the type_ field is not null.

However, because type_ is a nullable column, it is possible to not specify a value for type_ (and Liferay does so in portal-data-sample.vm in 5.1.x), resulting in null values in the database. When multiple null values are present, Liferay will be unable to add an index on Group_ (companyId, friendlyURL) because it would not have updated the friendlyURL on those groups.