User search and count for assigning site members is not consistent

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.X EE
• Fix Version/s: 6.2.X EE
• Component/s: Sites Management
• Labels:
  • liferay-fixpack-portal-123-6210
• Branch Version/s:
  6.2.x
• Backported to Branch:
  Committed
• Story Points: 1
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal-ee/pull/14726

When trying to search users when assigning members for a site, the select query searches in database and the count query in the index, which results (because of the wildcards used) in inconsistent results.

Steps to Reproduce:

1. In an empty bundle create six users with first name and screen name user1, user2,... up to six (the email will be [email protected], [email protected],...).
2. Create and additional user with first name and screen name zuser, and email [email protected]
3. Go to Admin > Site Administration > Users > Site Memberships > Add Members > User
4. Search users using literal u

Expected Results:
7 users should be found, and the message should be "Showing 7 results".

Current Results:
7 users are found, but the message is "Showing 6 results".