|
Given a map from entity AddressType to entity Address, running the query
SELECT ENTRY(r) FROM User f JOIN f.addresses r
produces invalid SQL:
select
addresses1_.addresses_KEY as col_0_0_,
addresses1_.addressType as col_0_1_,
addresses1_.addresses_id as col_1_0_,
address2_.street as col_1_1_
from
User user0_
inner join
User_Address addresses1_
on user0_.id=addresses1_.User_id
inner join
Address address2_
on addresses1_.addresses_id=address2_.id
It tries to select the column "addressType" (which is a column in AddressType) from the join table User_Address. Instead, the AddressType table would have to be joined, too, allowing to select its column(s).
|
