Re: Detecting when outer joins are needed [Was: Cayenne does not throw an exception when an outer join is attempted]

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Fri Aug 25 2006 - 02:45:43 EDT

  • Next message: Florian.Esk..i-de.com: "Florian Eska istaußer Haus."

    On Aug 23, 2006, at 11:35 PM, Mike Kienenberger wrote:

    > Here's where I'm finding that I need outer joins:
    >
    > 1) If two qualifiers for a non-mandatory relationship path are or'd
    > together. This is also what Øyvind Harboe reported. It may be that
    > the non-mandatory part is irrelevent.
    >
    > 2) If using noMatchExp on a non-null value for a non-mandatory
    > relationship path.

    Thanks Mike - that makes sense. I think "non mandatory" part is
    relevant. Not sure that we need to catch it though. IMO this should
    be left as an exercise to the user.

    Andrus

    This archive was generated by hypermail 2.0.0 : Fri Aug 25 2006 - 02:46:05 EDT