| 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: | Whole Thread | Raw Message | 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
| 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 |