FinderCache doesn't work properly when using null values in a null convertible string column (for all cases)

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X, Master
• Fix Version/s: 7.0.0 DXP FP62, 7.0.X, 7.1.10 DXP FP4, 7.1.10.1 SP1, 7.1.2 CE GA3, 7.1.X, Master
• Component/s: Core Infrastructure > Service Builder
• Labels:
  • INACTIVE
  • liferay-dxp-70-sp10
  • liferay-dxp-71-sp1
  • liferay-fixpack-de-62-7010
  • liferay-fixpack-dxp-4-7110
• Branch Version/s:
  7.1.x, 7.0.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/64702

After LPS-81028 there are still some methods where finderCache isn't working properly in the persistence layer.

Steps to Reproduce:

1. Execute the following Groovy script:

import com.liferay.counter.kernel.service.CounterLocalServiceUtil;
import com.liferay.portal.kernel.model.ListType;
import com.liferay.portal.kernel.service.ListTypeLocalServiceUtil;

ListType listType = ListTypeLocalServiceUtil.createListType(CounterLocalServiceUtil.increment());

listType.setName("Test");
listType.setType(null);

out.println("Result before update expected 0 is : " + ListTypeLocalServiceUtil.getListTypes(null).size());

listType = ListTypeLocalServiceUtil.updateListType(listType);

out.println("Result after update expected 1 is : " + ListTypeLocalServiceUtil.getListTypes(null).size());

ListTypeLocalServiceUtil.deleteListType(listType);

Expected Results:

Before the insertion no record should be found, but after inserting one must be returned.

 

Actual Results:

Before the insertion no record is found, but after inserting none (the cached value) is returned.