[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5351) Extra join is getting created in Hibernate 3.5.2.

Extra join is getting created in Hibernate 3.5.2. ------------------------------------------------- Key: HHH-5351 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5351 Project: Hibernate Core Issue Type: Bug Components: query-sql Affects Versions: 3.5.2 Environment: Hibernate-3.5.2-Final, Oracle 10g Reporter: Pravin Ramhari Pawde Original Estimate: 32h Remaining Estimate: 32h I had written a code for hibernate verion 3.3 and was working fine. bellow is the query:: ========================= SELECT DISTINCT employee0_.employee_id AS empl2_321_0_ FROM employee employee0_ LEFT OUTER JOIN department department1_ ON employee0_.station_id = department1_.department_id WHERE employee0_.discriminator = 'DEPARTMENT' AND employee0_.active = ? AND ( department1_.department_id IN ( ?, ? ) OR department1_.parent_department_id IN ( ?, ? ) OR employee0_.station_id IS NULL ) AND ( employee0_.type_identifier IS NULL OR employee0_.type_identifier <>? ) ======================================================== After I moved to Hibernate version 3.5.2 bellow is the query:: ======================== SELECT DISTINCT employee0_.employee_id AS empl2_321_0_ FROM employee employee0_ LEFT OUTER JOIN department department1_ ON employee0_.station_id = department1_.facility_id, department facility2_ WHERE department0_.discriminator = 'DEPARTMENT' AND employee0_.station_id = facility2_.facility_id AND employee0_.active = 'true' AND ( department1_.department_id IN ( ?, ? ) OR department1_.parent_department_id IN ( ?, ? ) OR employee0_.station_id IS NULL ) AND ( employee0_.type_identifier IS NULL OR employee0_.type_identifier <>? )