select NOT IN with NULL bug on 7.2b3

From: Giuseppe Tanzilli - CSF <g(dot)tanzilli(at)gruppocsf(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: select NOT IN with NULL bug on 7.2b3
Date: 2001-11-29 16:25:06
Message-ID: 3C066162.9070504@gruppocsf.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,
it is a bug ??

create table test (t1 int4, t2 int4);
insert into test values (1,1);
insert into test values (2,2);
insert into test values (3,1);
insert into test values (4,1);
insert into test values (4,1);
insert into test values (4,null);

select * from test where t1 not in (select t2 from test);
0 rows
select * from test where t1 not in (select null);
0 rows

If I delete the row with null value it works as expected.
The IN clause work as expected with or without null row.

sorry for my english.
bye

--
-------------------------------------------------------
Giuseppe Tanzilli g(dot)tanzilli(at)gruppocsf(dot)com
CSF Sistemi srl phone ++39 0775 7771
Via del Ciavattino
Anagni FR
Italy

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB SD 2001-11-29 16:27:50 Re: Second call for platform testing
Previous Message bangh 2001-11-29 16:06:02 Vacuum