public void testInCriterion() {
List<String> expectedNames = Arrays.asList("bigBird", "cookieMonster");
Query query = Query.select().where(Employee.NAME.in("bigBird", "cookieMonster")).orderBy(Employee.NAME.asc());
testInQuery(expectedNames, query);
query = Query.select().where(Employee.NAME.notIn("bigBird", "cookieMonster")).orderBy(Employee.NAME.asc());
testInQuery(Arrays.asList("bert", "elmo", "ernie", "oscar"), query);
List<String> list = Arrays.asList("bigBird", "cookieMonster");
query = Query.select().where(Employee.NAME.in(list)).orderBy(Employee.NAME.asc());
testInQuery(expectedNames, query);
query = Query.select().where(Employee.NAME.in(list).or(Field.field("1").neq(1))).orderBy(Employee.NAME.asc());
testInQuery(expectedNames, query);
}