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 <[EMAIL PROTECTED]> 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?


Reply via email to