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

[Andrus Adamchik]

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