> Consider the following:

> User user = new User();
> user.setName("user");
> Ebean.save(user);

> Role role1 = new Role();
> role1.setName("role1");
> Ebean.save(role1);
> user.getValidRoles().add(role1);
> Role role2 = new Role();
> role2.setName("role2");
> Ebean.save(role2);
> user.getValidRoles().add(role2);
> Ebean.save(user);

> List<Integer> roleIds = new ArrayList<Integer>();
> roleIds.add(role1.getId());
> List<User> result =
> Ebean.find(User.class).join("validRoles").where().in("validRoles.id",
> roleIds).findList();
> assertEquals(1, result.size());
> User resultUser = result.get(0);
> assertEquals(user, resultUser);
> assertEquals(2, resultUser.getValidRoles().size());

> It returns only the valid roles that are in the roleIds list. If I
> remove join("validRoles") from the query, the validRoles collection is
> lazy loaded (both roles) and the test passes. Surely this difference
> indicates a bug? JPA would always return the entire list of
> validRoles.

> /Daryl