|
to clarify, hibernate generate :
select
this_.id as id1_2_4_,
...
currency8_.code as code2_0_3_
from
opportunities this_
left outer join
currencies currency1_
on this_.currency_id=currency1_.id
left outer join
currency_conversions conversion3_
on currency1_.id=conversion3_.currency_id
and (
(
conversion3_.localCurrency=currency1_.code
and conversion3_.effectiveMonth=tcv2_.month
)
)
left outer join
splits tcv2_
on this_.id=tcv2_.opportunityId
left outer join
currencies currency8_
on tcv2_.currency_id=currency8_.id
order by
tcv2_.month
the sql response
Unknown column 'tcv2_.month' in 'on clause'
test case is attached
It is a eclipse export of this specific case.
|
