|Subject||Re: [firebird-support] Different result set firebird <--> oracle when comparing with "NULL"|
> select ID, SENDER_IDOracle often has an incorrect NULL handling.
> 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.
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!