[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1657?page=c... ] David commented on HHH-1657: ---------------------------- I have a similar but different bug to report. (If this is different someone place repost.) The problem is the update SQL comment doesn't use aliases so my inner query ends up referencing the wrong table. The following EJB QL query... UPDATE Provider p SET p.avgRating = (SELECT AVG(r.score) FROM Rating r WHERE r.providerFor = p) WHERE p.id = 44; becomes... update Provider set avgRating=(select AVG(rating1_.score) from Rating rating1_ where rating1_.providerFor_id=id) where id=44; This query isn't correct. The 'id' at the end of the where of the inner select does not refer to the id of the Provider as it should, instead the id ends up referencing Rating which obviously isn't what i want. This EJB QL query really should be generating the following SQL query which uses aliases: update Provider p set p.avgRating=(select AVG(rating1_.score) from Rating rating1_ where rating1_.providerFor_id=p.id) where p.id=44; (I don't know a way around this so for the time being I am resorting to using a native query.) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira