Hi,

I'm trying to write a complex query in hql.

According to the documentation a subquery is possible in select in hql:

Exemple given in doc:

select cat.id, (select max(kit.weight) from cat.kitten kit)
from Cat as cat

My query :

select pi.mId, (select max(si.mId) from pi.mSI si)
from PI as pi

My object PI has a collection of object SI.

When I execute my query, i've got an org.hibernate.QueryException: aggregate function expected before, why?
and why the keyword 'as' is not use in the subquery for alias kit in exemple?


Edit: Ok I've found the solution, it 'seems that to use the subquery in select the ASTQueryTranslatorFactory is needed!
The hibernate documentation dont talk about it!