Horton

A bug in NOT IN (SELECT ...

Hannu Krosing <hannu@tm.ee>

View thread
From: Hannu Krosing <hannu@tm.ee>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: PostgreSQL-development <pgsql-hackers@postgreSQL.org>
Date: 1999-11-02T08:11:55Z
Lists: pgsql-bugs, pgsql-hackers

Attachments

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