I am in the process of migrating from Hibernate 2.0 to Hibernate 3.0.
I am attempting to execute a Hibernate 3.0 query that was generated from an HQL string. The following is an example of the HQL I am using:

SELECT p.id
FROM Person p LEFT JOIN p.names name
WHERE name.myName = :myName

The following is an example of the generated SQL string:

select * from (
select person0_.ID as col_0_0_
from PERSON person0_ ,
left outer join NAMES na1_ on person0_.ID=na1_.ID
where na1_.MY_NAME)=upper('test') )
where rownum <= 50

Notice that it is adding a comma (,)