[hibernate-issues] [Hibernate-JIRA] Closed: (EJB-423) Smarter Joins - One instead of Two

Smarter Joins - One instead of Two ---------------------------------- Key: EJB-423 URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-423 Project: Hibernate Entity Manager Issue Type: Improvement Components: EntityManager Affects Versions: 3.3.1.GA Environment: Hibernate with PostgreSQL Reporter: Bradford Priority: Minor I have CompanyLocation that has a station property as ManyToOne with Station. StationLocale has a station property as ManyToOne with Station. I created a OneToMany relationship in Station that's called localizedStation. If I write the following: left join colocs.station.localizedStation as sl It creates two left joins when it gets converted to SQL: left outer join stations station4_ on companyloc0_.station_code=station4_.code left outer join station_locales localizeda5_ on station4_.code=localizeda5_.station_code This is a waste. Shouldn't it be smart enough to generate the following: left outer join station_locales localizeda5_ on companyloc0_.station_code=localizeda5_.station_code