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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs 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 | Content-Type | Size |
---|---|---|
testcase.sql.gz | application/x-gzip | 1.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | David Sauer | 1999-11-02 14:20:12 | I can't do typecasting... |
Previous Message | Bruce Momjian | 1999-11-02 04:05:47 | 6.5.3 is ready |
From | Date | Subject | |
---|---|---|---|
Next Message | Gene Sokolov | 1999-11-02 09:01:46 | Re: [HACKERS] file descriptors leak? |
Previous Message | Andrij Korud | 1999-11-02 07:15:14 | Re: [HACKERS] Get OID of just inserted record |