Subject Re: [firebird-support] Different result set firebird <--> oracle when comparing with "NULL"
Author Martijn Tonies
> select ID, SENDER_ID
> from T_BILL
> where SENDER_ID not in ( select id from T_CONTACT )
> "SENDER_ID" is set 'NULL' in every dataset.
> Oracle returns zero datasets, firebird returns the whole table.
> As I am not a sql guru, I don't know if this behavior is defined in
> sql, but I find it interesant, that the 2 databases act different.

Oracle often has an incorrect NULL handling.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!