I believe I have found a bug when ordering by a property of a property.
I am not sure where to post bugs so I will do it here until I get directed to otherwise.

I have one class with a relationship to another enitity. Retrieving a list of objects works fine. But when I sort by a property of the related class I get weird results. The query fails to return objects where the related entity is null.

here is the query:


here is the resulting sql from the query:


The code creating the query has wrongfuly added this jobpost0_.memberid=member1_.memberid. The member can be null so incorrect results are produced. I believe a join should be created in this instance.

Let me know if I should post this somewhere else or if you need any more info.

Well, you do get a join, but it's an inner join. If you want to get a left join, you need to alter the query to specify it explicitly:

yes but since its an assosciation, isnt it assumed that it should be an outer join. Im not filtering on the assosciation, just sorting.

Seems like an unexpected result to me.

HQL is a hybrid between objects and SQL, so some results might be unexpected. As in SQL, the default in HQL are inner joins.