When query joins to a many property and has a firstRow or maxRows setting then:
- the SQL to limit the result should not be added
- the join to the Many property should be removed from the query
In v2.0. of Ebean the check for this is broken (incorrect boolean expression in CQueryBuilder) and you end up with the join to the many property AND the limit clause.
This means the returned result can often not have the correct number of root level objects.