Hibernate version: 3.0.5 and 3.1beta2



Its seems that a left outer join query executed inside a subquery does not work.

In fact, the sql query generated by hibernate for this example :

" select o1 from table1 as o1 where o1.id in ( select o.id from table1 as o left outer join o.comps as comp where .... ) "

will be :

" select o1 from table1 as o1 where o1.id in ( select o.id from table1 o, table2 comp where .... ) "

instead of

" select o1 from table1 as o1 where o1.id in ( select o.id from table1 o left outer join table2 comp on o.id = comp.id where .... ) ".

I hope i am quite clear. To be short, " from table1 left outer join table2" is interpreted as "from table1, table2".

"theta-style" joins are used inside subqueries

Does this explains why I do not get the same result when the same request is executed inside a subquery or not ?
Does this mean that we can't use a "left outer join" inside a subquery ?

I would like to add that when I execute the request inside a subquery, no join is performed at all, I mean that there is no "where o.id = comp.id" of "theta-style" join that replaces the join of "ANSI-style" join.