A query like:
{ { code}
String queryHQL = "from InvestmentCompany investmentCompany "
+ "where exists "
+ "(select employee "
+ "from investmentCompany.employees as employee "
+ " where lower(employee.firstName) like :param1 )";
{code } }
Results in SQL:
{ { code}
SELECT
investment0_.id AS id1_0_,
investment0_1_.fullName AS fullName2_0_,
investment0_1_.shortName AS shortNam3_0_,
investment0_.investorType AS investor1_2_
FROM
InvestmentCompany investment0_
INNER JOIN
CompanyBase investment0_1_
ON investment0_.id=investment0_1_.id
WHERE
EXISTS (
SELECT
employees1_.id
FROM
Employee employees1_
WHERE
investment0_.id=employees1_.company_id
AND (
LOWER(employees1_1_.firstName) LIKE ?
)
)
{code } }
The alias {{employees1_1_}} should be {{employees1_}}. |
|