For example, the following query:
causes the following error on execution:
This happens because actual parameter values are passed in wrong order, not following parameter's positions (?1, ?2...), leading to type mismatch.
This bug may occur not only when IN predicate is used, but in any query with multiple named parameters. As a result, it may cause type conversion exception, or wrong return result – if all values match types, but are misordered.