Hi,

Has anyone experienced the following strange behavior?

When I execute a query like this:

select item.name, elements(item.photos) from Item item left join item.photos where item.id=1

The result is empty if the item does not have any photos; and the result is correct if the item has photos. "Photo" represent another table and is mapped with many-to-one relationship in the Photo class, and a one-to-many set in the Item class.

It doesn't seem to honor "left join" with which i hope to get a row with a value for item.name and a null for item.photos in case there's no photos in the set.

Of course the result is not empty in all cases if the query is selecting everything from Item, e.g. using something like "from Item item..." to start with, but that's not a query i want because i don't want to retrieve other fields including a large text field.

If anyone can tell me why it is so and how to get around the problem, it'll be most appreciated!

Thank you, Michael!

That worked. That's fantastic! i've been hanging over this problem for more than a day and was was just ready to switch to bare JDBC :-)