JPA Criteria: Invalid SQL with IN predicate

JPA Criteria is awesome when you need to compose complex queries from multiple blocks, but it can cause a lot of troubles when the underlying SQL code fails to check some obvious scenarios. The concept When dealing with Java Lists, we can almost alwa...