[ic] some issues with 5.0 and oracle
jon at endpoint.com
Wed Feb 4 17:05:55 EST 2004
On Wed, 4 Feb 2004, Stefan Hornburg wrote:
> > Equality and inequality operators do not operate on NULLs. So if your
> > table contains only null "foo" fields, it is correct to say the count() of
> > rows where foo <> (or != if you prefer) 1 is 0. This is how SQL NULLs work
> > -- they are not values; they're the absence of values. See:
> > http://www.mysql.com/doc/en/Working_with_NULL.html
> > Incidentally both PostgreSQL and MySQL accept != as a synonym for <> but
> > it is <> that is defined in SQL, and I do not believe Oracle accepts !=.
> Therefore inactive needs to be NOT NULL for all RDBMS.
That would be great, but you'll want to test it pretty extensively before
committing it. Interchange has a few remaining spots where NOT NULL causes
trouble, IIRC especially for userdb.
More information about the interchange-users