Hibernate doesn't support empty collection as parameter of javax.persistence.criteria.Expression "in" method parameter ---------------------------------------------------------------------------------------------------------------------- Key: HHH-6876 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6876 Project: Hibernate Core Issue Type: Bug Components: query-criteria, query-hql Affects Versions: 4.0.0.CR6 Environment: Using Mysql5.1 (org.hibernate.dialect.MySQL5InnoDBDialect) Reporter: Yann Le Moigne Looking at http://docs.oracle.com/javaee/6/api/javax/persistence/criteria/Expression..., there is nothing said about empty collection, so, we presume it is possible to use it. If this presumption is right, well hibernate break the spec because using empty collection as a parameter will end with something like "org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [select generatedAlias0 from MyEntity as generatedAlias0 where generatedAlias0.id in ()] -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira