The following query:

FROM it.saga.pubblici.tributi.TriDACCalcoloVoci as voce WHERE voce.pkid IN
(SELECT v.pkid FROM it.saga.pubblici.tributi.TriDACCalcoloVoci as v
LEFT JOIN v.sottoPeriodo as sp)

do not work with Hibernate 3.0.3 and SQL Server, while it worked with Hibernate 2.1.6 and the same DB.

The bug is in the translation from HQL to SQL because the result SQL query is:

select [omississ] from TRI_CALCOLO_VOCI tridaccalc0_ where tridaccalc0_.pkid in
(select tridaccalc1_.pkid from TRI_CALCOLO_VOCI tridaccalc1_,
left outer join TRI_CALCOLO_SOTTOPERIODO tridaccalc2_ on tridaccalc1_.id_sottoperiodo=tridaccalc2_.pkid)

The problem is that comma (,) just before the LEFT OUTER JOIN: that comma must not be there at all!
If I change my query and use a INNER join the comma (,) is ok, and so the query works perfectly ... but, of course, I can't do that.
Moreover if the nested query is executed alone (i.e. SELECT v.pkid FROM it.saga.pubblici.tributi.TriDACCalcoloVoci as v LEFT JOIN v.sottoPeriodo as sp) it works!

Is this a known bug?
Can anybody tell me when is going to be solved?

Tell me if you need more information (mappings or things like this ... I did not send them because they are quite complex ... and I think you can easlily reproduce the bug).

Regards
Alessandro Rizzi

I tried just now with Hibernate 3.0.5 and I have the same bug.
Alessandro

please post in to JIRA

Done, the key is HHH-577
Thanks

Gavin says this is a duplicate of another bug, and I supposed it's the HHH-554, so I download from CVS version 3.1 alfa which solves this bug, but I still have it.

I think my problem is a little different because I have it only with nested subqueries, not with simple query.

Do you need a full test case?

Thanks for help
Alessandro