Re: orExp resulting in *fewer* results

From: Øyvind Harboe (oyvind.harbo..ylin.com)
Date: Tue May 30 2006 - 10:56:30 EDT

  • Next message: Andrus Adamchik: "Cayenne 1.2 Release Candidate is available"

    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

    This archive was generated by hypermail 2.0.0 : Tue May 30 2006 - 10:57:04 EDT