Re: orExp resulting in *fewer* results

From: Tore Halset (halse..vv.ntnu.no)
Date: Tue May 30 2006 - 09:40:34 EDT

  • Next message: Øyvind Harboe: "Re: orExp resulting in *fewer* results"

    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.

      - Tore.



    This archive was generated by hypermail 2.0.0 : Tue May 30 2006 - 10:12:48 EDT