BUG #8934: value != ANY (uuid[]) AND expr does not work in all cases

Поиск
Список
Период
Сортировка
От marcusoverheu@gmail.com
Тема BUG #8934: value != ANY (uuid[]) AND expr does not work in all cases
Дата
Msg-id 20140123094712.26700.15844@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #8934: value != ANY (uuid[]) AND expr does not work in all cases
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8934
Logged by:          Marcus Overheu
Email address:      marcusoverheu@gmail.com
PostgreSQL version: 9.2.4
Operating system:   ubuntu 12.04.3
Description:

if you have a table ala.
 create table uuidtest( aint integer, auuid uuid);

 insert into uuidtest VALUES (1, 'ab15ea27-8768-4cbe-a1fb-02a2a949a34d'),
(1, '1c9e9ce5-d4d8-4a14-9eaf-929f27e09ba2');

then
 select * from uuidtest where auuid = ANY
(ARRAY['1c9e9ce5-d4d8-4a14-9eaf-929f27e09ba2','ab15ea27-8768-4cbe-a1fb-02a2a949a34d']::uuid[])
and aint = 1;
return 2 result
which would mean that if using not in

select * from uuidtest where auuid != ANY
(ARRAY['1c9e9ce5-d4d8-4a14-9eaf-929f27e09ba2','ab15ea27-8768-4cbe-a1fb-02a2a949a34d']::uuid[])
and aint = 1;

would return zero, but it stills returns 2 results.

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