Incorrect join used when where expression has a many property and ends with a foreign key column

[rbygrave]

Example:

Query<Order> query = Ebean.find(Order.class)
  .where().eq("details.product.id", productId)

"details" is a many property and "product.id" maps to a foreign key column.

For predicates on expressions that contain a 'many property' a separate join should be built for the predicate (separate from a fetch join). These joins have table alias' starting with 'u' rather than fetch joins which have joins starting with 't'.