Re: [JIRA] Commented: (CAY-560) Add support for outer joins

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue Jun 12 2007 - 12:07:11 EDT

  • Next message: Andrus Adamchik: "Re: [JIRA] Commented: (CAY-560) Add support for outer joins"

    Ok, got it. Yeah the DB would evaluate any condition that has a NULL
    in it as FALSE. No objections to making Cayenne follow the Java
    convention in that respect.

    Andrus

    On Jun 12, 2007, at 6:57 PM, Mike Kienenberger wrote:
    > It was dealing with Oracle (and other Databases) requiring expressions
    > in this format:
    >
    > (a <> ? or a is null)
    >
    > instead of
    >
    > (a <> ?)
    >
    > I'm pretty sure that was the expression, but I can't remember the
    > details -- you were already aware of the problem at the time.
    >
    >
    > On 6/12/07, Andrus Adamchik <andru..bjectstyle.org> wrote:
    >> One las question - a CAY-560 comment says "[provides] Outer Join
    >> support as well as inequality expression null handling." Could you
    >> remind what was the deal with inequality expression null handling?
    >

    This archive was generated by hypermail 2.0.0 : Tue Jun 12 2007 - 12:07:34 EDT