'Not able to get how the system is generating below Query
I'm passing manual query with 1st table primary key = second table foreign key with left join but system generating in the logs 1st table primary key = second table primary with left outer join.. I Did 't get why this behavior comes.. Please any one can explain this one.
Manual Query:
select new com.app.model.EmployeeValues(emp.name,ed.permentaddres,ed.presentaddr,ed.qualification) from com.app.model.Employee emp left join com.app.model.EmployeeDetails ed on emp.id=ed.id where emp.name = :empName
System Generated Query:
select employee0_.name as col_0_0_, employeede1_.permentaddres as col_1_0_, employeede1_.presentaddr as col_2_0_, employeede1_.qualification as col_3_0_ from employee employee0_ left outer join employee_details employeede1_ on (employee0_.Id=employeede1_.details_id) where employee0_.name=?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
