[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Nick Folder commented on HHH-2667: ---------------------------------- "Query language changes Implicit joins are more deterministic With such mapping: <class name='Currency' lazy='false'> .... </class> <class name='Asset'> <id name='id' ... </id> <many-to-one name='currency' class='Currency' fetch='select'/> </class> and such HQL query: select a.id, a.currency from Asset a Since Hibernate 3.2.2 this query generates an inner join on Asset with Currency which means that Assets with a NULL currency are not returned by the query anymore. This makes implicit joins more deterministic. To get Assets with a NULL currency just use select a.id, c from Asset a left join a.currency as c Path expressions joining across a collection throw exception The always illegal statement: select f.bars.baz from Foo f Now throws an exception. Despite the always present warning in the documentation that this is an illegal path expression if bars is a collection, users found this to be working in some cases with Hibernate 3.1. This is no longer the case, an error is thrown. As always, the correct syntax is an explicit join: select b.baz from Foo f join f.bars b" -- 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