Skip site navigation (1) Skip section navigation (2)

A bug in NOT IN (SELECT ...

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: A bug in NOT IN (SELECT ...
Date: 1999-11-02 08:11:55
Message-ID: 381E9CCB.A46CDF62@tm.ee (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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: testcase.sql.gz
Description: application/x-gzip (1.9 KB)

In response to

Responses

pgsql-hackers by date

Next:From: Gene SokolovDate: 1999-11-02 09:01:46
Subject: Re: [HACKERS] file descriptors leak?
Previous:From: Andrij KorudDate: 1999-11-02 07:15:14
Subject: Re: [HACKERS] Get OID of just inserted record

pgsql-bugs by date

Next:From: David SauerDate: 1999-11-02 14:20:12
Subject: I can't do typecasting...
Previous:From: Bruce MomjianDate: 1999-11-02 04:05:47
Subject: 6.5.3 is ready

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group