I believe agree that the bug here is that an ANSI-style the SQL theta join is not being generated for the implicit HQL join (e.department) when an attribute of does not follow the joined entity (e.department.deptName) is selected ANSI-style joins in the SQL generated for :
{code}
select e.lastName, e.department.deptName, e.title from Employee e
{code}
As a workaround, the implicitly joined entity can be selected instead; theANSI the ANSI -style join is correctly generated in this case:
{code}
select e.lastName, e.department, e.title from Employee e
{code}
When processing the second column (e.department) returned, simply call Department.getDeptName() to get the value for e.department.deptName.
|
