Re: inner or outer join?

From: Andrey Razumovsky (razumovsky.andre..mail.com)
Date: Tue Jan 26 2010 - 06:19:40 EST

  • Next message: Andrey Razumovsky: "Re: Apache retreat in Ireland"

    I'm very surprised it is left join by default. I think it should be inner
    join, as it is also analogue with SelectQuery (e.g. "artist" path in
    expression means inner Join). What does specification say?

    2010/1/26 Andrus Adamchik <andru..bjectstyle.org>

    > We had an offline conversation about that with Ksenia. I should clarify
    > that we are talking about EJBQL "SELECT" clause. As in "SELECT p.artist
    > FROM Painting p"
    >
    > Andrus
    >
    >
    > On Jan 26, 2010, at 12:35 PM, Khailenka Xenia wrote:
    >
    > There is a question which join strategy would be better to use implicitly
    >> when supporting the relationship with the other entity - inner or outer.
    >> On
    >> the one hand, the inner join allow to avoid entities with null references
    >> when we want to restrict the result set, on the other hand we can lose
    >> these
    >> entities when we not care about those references. Now the outer join is
    >> implicitly used and that results in ability to get the null entity at the
    >> result set. Any thoughts?
    >>
    >> --
    >> Regards, Ksenia Khailenko
    >>
    >
    >

    -- 
    Andrey
    



    This archive was generated by hypermail 2.0.0 : Tue Jan 26 2010 - 06:20:30 EST