The specified HQL:

select
u,
case..when..then..end as myalias
from User u

doesn't generate the specified alias myalias in the SQL query but instead a default hibernate one col_1_0_

This seems to be a bug in Hibernate. Right?

Bruno

I don't think Hibernate makes any promises to use the same aliases in the generated SQL as was used in HQL.

So how do I do to sort on myalias?

if I add the following order by clause at the end of the HQL: order by myalias

I would expect Hibernate to keep track of the HQL<->SQL alias and use the proper alias in the SQL, but... maybe I am wrong. It seems like there are some limitations:

http://www.hibernate.org/hib_docs/v3/re ... l-ordering

my workaround is to use order by col_1_0_ in the hql :-) what works fine
but i will not feel safe in production..

Yes, this seems a bit risky.