This occurs when there are multiple elements in a collection in the query parameter, e.g., ‘WHERE e.name IN (:employeeNames)’. Here, if the List<String>
employeeNames has exactly one element, the query runs fine; however, for more than one element, the query fails.
I am using Hibernate 6.3.1