BUG #6701: IS NOT NULL doesn't work on complex composites

Поиск
Список
Период
Сортировка
От rikard.pavelic@zg.htnet.hr
Тема BUG #6701: IS NOT NULL doesn't work on complex composites
Дата
Msg-id E1ShNDt-00005k-8t@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #6701: IS NOT NULL doesn't work on complex composites  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: BUG #6701: IS NOT NULL doesn't work on complex composites  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: BUG #6701: IS NOT NULL doesn't work on complex composites  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6701
Logged by:          Rikard Pavelic
Email address:      rikard.pavelic@zg.htnet.hr
PostgreSQL version: 9.1.3
Operating system:   Windows 7
Description:=20=20=20=20=20=20=20=20

create type t AS (i int);
create type complex as (t t, i int);
create table bad(i int, c complex);

insert into bad values(1, null);
insert into bad values(1, ROW(null, 2));
insert into bad values(1, ROW(ROW(1), 2));

select * from bad;
select * from bad where c is null;

--This doesn't work as expected
select * from bad where c is not null;

--Fortunately a workaround
select * from bad where NOT c is null;

В списке pgsql-bugs по дате отправления:

Предыдущее
От: msrbugzilla@gmail.com
Дата:
Сообщение: BUG #6700: Potential Bug in numeric.c
Следующее
От: Michael Meskes
Дата:
Сообщение: Re: BUG #6700: Potential Bug in numeric.c