cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Øyvind Harboe <oyvind.har...@zylin.com>
Subject Re: orExp resulting in *fewer* results
Date Tue, 30 May 2006 14:56:30 GMT
On Tue, 2006-05-30 at 15:40 +0200, Tore Halset wrote:
> On May 30, 2006, at 15:28, Øyvind Harboe wrote:
> 
> > On Tue, 2006-05-30 at 15:10 +0200, Tore Halset wrote:
> >> On May 30, 2006, at 10:25, Øyvind Harboe wrote:
> >>
> >>> If I manually modify the generated query from the orExp() case to  
> >>> use
> >>> a LEFT OUTER JOIN instead of INNER JOIN, I get the expected
> >>> result.
> >>
> >> AFAIK Cayenne does not support outer join yet. Google got me to this
> >> one:
> >
> >
> > Oooopsss.... The JOIN is a red herring here. See corrected summary  
> > of my
> > problem.
> >
> > The INNER JOIN is not generated by Cayenne from the Java
> > code. I copied the SELECT statement into MS SQL manager and it will
> > rewrite Cayenne's SQL statement to contain an INNER JOIN as part of  
> > the
> > reformatting.
> 
> "WHERE ...  t0.ELCROLE_ID = t1.ELCROLE_ID AND" is "inner join" and  
> you want "outer join". See my prev answer.

Gotit. 

Are there any plans or working notes on adding support to Cayenne for
OUTER JOINs? I didn't find a CAY-xxx feature request.

Not for the faint of heart to add to Cayenne I take it.

-- 
Øyvind Harboe
http://www.zylin.com


Mime
View raw message