]
Gail Badner resolved HHH-5351.
------------------------------
Assignee: Gail Badner
Resolution: Duplicate
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
Assignee: Gail Badner
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 <>? )
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: