elements() and subselects

rhobot · **Joined:** Fri Aug 29, 2003 12:48 pm **Posts:** 63

Hibernate version:
2.1.6

Is it legal to compare an elements() clause against a subselect? E.g.

Code:

select from Parent p where some elements(p.children) in (select from Children c where c.big.long.complex.path.here = ?)

Having some trouble with undefined aliases when I try to run this query. Is this totally not allowed? Should we be doing a join query instead and take care of getting unique parents ourselves?

christian · **Posted:** Fri Aug 27, 2004 3:41 pm

Yes, use a join.

rhobot · **Joined:** Fri Aug 29, 2003 12:48 pm **Posts:** 63

Fair enough, but is there any way to get unique parents in hql? e.g.

Code:

select unique Parent p join p.children ...

or do we have to do that in Java? That's the only reason we were messing about with the elements() pseudofunction stuff in the first place.[/code]

rollatwork · **Posted:** Fri Aug 27, 2004 4:02 pm

Could you not use "select distinct..."?

rhobot · **Joined:** Fri Aug 29, 2003 12:48 pm **Posts:** 63

unique == distinct

But apparantly not, unless we were borking the hql in some fashion. Was hoping for definitive word on doing unique/distinct queries with joins, it doesn't seem to work or even make sense offhand.