[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1837) discussion: implicit joins are always INNER

[Steve E. (JIRA) <no...@at...>]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1837?page=comments#action_23341 ] 

Steve Ebersole commented on HHH-1837:
-------------------------------------

Not to mention it is already discussed in the doco:
http://www.hibernate.org/hib_docs/v3/reference/en/html/queryhql.html#queryhql-joins-forms


> discussion: implicit joins are always INNER
> -------------------------------------------
>
>          Key: HHH-1837
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1837
>      Project: Hibernate3
>         Type: Improvement

>     Reporter: Bill Schneider

>
>
> It would be helpful to explain the consequences in the docs re. implicit joins always resulting in INNER joins.  
> This causes semantics of HQL expressions to be quite different from similar-looking JSTL expressions.  
> in particular consider (copied from comment on HHH-989) this HQL expression
> "cat.mate.name= ? OR cat.name=?"
> if cat.mate is null, this will not return any results, **even if**  the right hand cat.name=? expression matches.
> A similar condition in JSTL (<c:if test="${cat.mate.name = ... || cat.name = ...}">) would behave differently.
> The HQL behavior may be correct, but sure could be confusing at first.

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