cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrey Razumovsky <>
Subject Re: inner or outer join?
Date Tue, 26 Jan 2010 11:19:40 GMT
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 <>

> 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


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message