Andrus,
There are some unit tests for outer joins that I created while I was
doing my own patch.
Maybe these can be reused. I'm pretty sure they're included in the
outer join jira issue.
On 6/12/07, Andrus Adamchik <[EMAIL PROTECTED]> wrote:
We had extensive discussions with Mike K. on advanc
On Jun 12, 2007, at 8:35 AM, Andrus Adamchik wrote:
SELECT t0.ARTIST_NAME AS ARTIST_NAME, t0.ARTIST_ID AS ARTIST_ID,
t0.DATE_OF_BIRTH AS DATE_OF_BIRTH
FROM ARTIST AS t0
INNER JOIN PAINTING AS t1 ON (t0.ARTIST_ID = t1.ARTIST_ID)
INNER JOIN PAINTING AS t2 ON (t1.ARTIST_ID = t2.ARTIST_ID)
We had extensive discussions with Mike K. on advanced join semantics
(and its limitations) in Cayenne. Here is a solution to controllable
joins coming from the JPA work. Let's say we are selecting artists
who have both paintings "P1" and "P2". You can't do it with
SelectQuery, as Cayenne wo