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. On 8/17/06, Andrus Adamchik <[EMAIL PROTECTED]> wrote:
> Would it make sense for Cayenne to throw an exception when an outer > join is attempted? Could you be more specific on when it should detect that? IIRC there were some discussions on that in the past. You provide no references though. Also there is an effort underway to support outer joins (we will have to do it in 3.0 anyways as the goal is to be compatible with the JPA spec that requires them): http://objectstyle.org/cayenne/lists/cayenne-devel/2006/08/0106.html Andrus On Aug 17, 2006, at 3:24 AM, Øyvind Harboe wrote: > Outer joins are not supported, I know. > > Meanwhile I miss being *told* when I'm attempting an outer join, > minimally runtime. > > One of the reasons I'm using Cayenne is that I don't want to think > about SQL, so I don't. It hurts even thinking about thinking about how > Cayenne Expressions turn into SQL statements :-) > > Would it make sense for Cayenne to throw an exception when an outer > join is attempted? > > Could I attempt to implement such a detection in Cayenne myself and > submit a patch or is it fiendishly difficult?
