A bug in NOT IN (SELECT ... - Mailing list pgsql-hackers

From Hannu Krosing
Subject A bug in NOT IN (SELECT ...
Date
Msg-id 381E9CCB.A46CDF62@tm.ee
Whole thread Raw
In response to 6.5.3 is ready  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: A bug in NOT IN (SELECT ...
List pgsql-hackers
Hi,

Pleas post this to approproiate lists also, as I'm currently
rejected from lists due to address change.

I am running 6.5.2 on RH Linux 6.0 and I have a following bug
(the dump of two tables involved is attached)

hannu=> select title from document where subject not in (
hannu-> select full_path from group_directory);
title
-----
(0 rows)

hannu=> select title from document where not subject in (
hannu-> select full_path from group_directory);
testcert
.
.
.
tester
tester
lugu
hlhkllk
(26 rows)

What's even more scary is that a little after trying to get it
work right and doing the first query a lot, I got a server crash
with corrupted shared memory, that had to be cured with a reboot
(was faster than finding docs for ipcclean)

-----------------
Hannu
Attachment

pgsql-hackers by date:

Previous
From: Andrzej Mazurkiewicz
Date:
Subject: inheritance of functions
Next
From: Zeugswetter Andreas SEV
Date:
Subject: Re: [HACKERS] Trigger aborted on error