Count* and related fetch* methods are returning inconsistent results when using null values in a null convertible string column

• Type: Regression Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X, Master
• Fix Version/s: 7.0.0 DXP FP67, 7.0.X, 7.1.10 DXP FP5, 7.1.10.1 SP1, 7.1.2 CE GA3, 7.1.X, 7.2.X, Master
• Component/s: Core Infrastructure > Service Builder
• Labels:
  • INACTIVE
  • liferay-dxp-70-sp10
  • liferay-dxp-71-sp1
  • liferay-fixpack-de-67-7010
  • liferay-fixpack-dxp-5-7110
• 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/65755

After LPS-81028 pair methods like countByG_P_L_P_A/fetchByG_P_L_P_A return inconsistent results when using null in null convertible string column because the first one is caching using null as part of the key, but not when invalidating, and the later is always retrieving the correct result from the database.