[rules-dev] need advice re null handling

Thursday, 15 March 2007

http://jira.jboss.com/jira/browse/JBRULES-627

OK, this much is clear:

Foo(field == null) can be true if field is null.

but, what about Foo(field > 3), and field is null? should that be false?
what about Foo(field != 3) - should that be true?

in SQL, null will always result in a false condition, unless you explicitly
use null.

Thoughts?

Michael.