[nhibernate-issues] [JIRA] Commented: (NH-514) Allow expansion of the "on" clause in joins.

[NHibernate J. <mik...@us...>]

     [ http://jira.nhibernate.org/browse/NH-514?page=comments#action_14414 ]
     
Luis Ferreira commented on NH-514:
----------------------------------

Hibernate filters should also, in my opinion, add their conditions to the "on" clause.

> Allow expansion of the "on" clause in joins.
> --------------------------------------------
>
>          Key: NH-514
>          URL: http://jira.nhibernate.org/browse/NH-514
>      Project: NHibernate
>         Type: Improvement
>   Components: Core
>     Versions: 1.0
>     Reporter: Dave McMullan
>     Priority: Critical
>      Fix For: LATER

>
> In english, I want a list of trades in a portfolio, whether tradeprices exist or not... but if they exist, they should be dated at least 7/1/2005. 
> In oracle, it looks like: 
> from trade t, tradeprice tp where t.portfolio=53 and tp.tradeid(+)=t.tradeid and tp.effdate(+) >= '1-Jul-2005' 
> In ansi, it looks like: 
> from trade t left outer join tradeprice tp on t.tradeid=tp.tradeid and tp.effdate >= '1-Jul-2005' where t.portfolio=53 
> In HQL, the closest I can get is: 
> from trade t left join fetch t.tradeprices tp where t.portfolio=53 and tp.effdate >= '1-Jul-2005' 
> But that HQL generates this incorrect SQL: 
> from trade t left outer join tradeprice tp on t.tradeid=tp.tradeid where t.portfolio=53 and tp.effdate >= '1-Jul-2005' 
> This SQL is not correct because the effdate condition needs to be in the "on" clause, not the "where" clause. But the "on" clause is generated internally by NHibernate, and I haven't found a way to alter it. Is there a way? 
> btw... tradeprice is a lazy init bag on trade object
> related forum topic: http://forum.hibernate.org/viewtopic.php?t=952606&highlight=outer+join

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira