A bug in NOT IN (SELECT ...

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