[ic] some issues with 5.0 and oracle

Jon Jensen 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 mailing list