Bug#488207: postgres don't return any rows with clause "not in" when null is present

[Claude K. Poitras]

Package: postgresql-8.1
Version: 8.1.11-0etch1

Try this:
create table a(id integer);
create table b(id integer);
create table c(id integer);

insert into a values(1);
insert into a values(2);
insert into a values(3);

insert into b values(6);
insert into b values(7);
insert into b values(8);

insert into c select id from a;
insert into c select id from b;

insert into c values(0);
insert into c values(5);
insert into c values(10);

select * from c where id not in (select id from a union select id from b);

you got:
 id 
----
  0
  5
 10
(3 rows)

But after you insert a NULL in table A: 
insert into a values(null);

select * from c where id not in (select id from a union select id from b);

You got:

 id 
----
(0 rows)

This not good.



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]