Adding a custom query parameter of value 0 with CustomSQLParam will not be included in the execution

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.1.1 CE GA2, 6.1.20 EE GA2
• Fix Version/s: 6.1.30 EE GA3, 6.2.0 CE M5
• Component/s: Portal Services, Portal Services > Legacy
• Labels: None
• Branch Version/s:
  6.1.x
• Backported to Branch:
  Committed
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/9160

When creating a custom query with CustomSQLParam passing in a value of 0, it will not include that parameter within the execution of the query.

If you try something like:
userParams.put("usersOrgs", new Long(0));

and then execute a search passing in the params, it will return an exception: org.hibernate.QueryException: Expected positional parameter count