Received: from tech.com.au (IDENT:root@techpt.lnk.telstra.net [139.130.75.122]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA00620 for ; Fri, 25 Jun 1999 10:58:36 -0400 (EDT) (envelope-from chris.bitmead@bigfoot.com) Received: from bigfoot.com (IDENT:chris@localhost [127.0.0.1]) by tech.com.au (8.9.3/8.9.3) with ESMTP id AAA08292 for ; Sat, 26 Jun 1999 00:58:23 +1000 Sender: chris@tech.com.au Message-ID: <3773990C.B58264C1@bigfoot.com> Date: Sat, 26 Jun 1999 00:58:20 +1000 From: Chris Bitmead X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.2.9 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-hackers@hub.org Subject: Severe SUBSELECT bug in 6.5 CVS References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Using the very latest CVS I'm encountering a bug in SUBSELECTs. This query returns 22 rows... SELECT id,title FROM question; This query returns 15 rows... SELECT id,title FROM question WHERE question.id IN (SELECT webobject FROM comment); Therefore I would expect this query to return 7 rows. Instead it returns none.... SELECT id,title FROM question WHERE question.id NOT IN (SELECT webobject FROM comment); I've tried it with a newly dumped and created database and it still happens. However I can't get it to happen on a new and empty database with simple data. In other words I can't come up with a simple test case. All I can think to do therefore is put my data in a file for download. It is 100k. ftp://ftp.tech.com.au/pub/datadump.gz As an aside, while creating this dump I tried to load it into another database and drop a few tables to make it smaller. I then tried to dump it again and got the following error... dumpRules(): SELECT failed for table productv. Explanation from backend: 'ERROR: cache lookup of attribute 1 in relation 1864370 failed -- Chris Bitmead mailto:chris@tech.com.au