Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA7MmXm28241 for ; Wed, 7 Nov 2001 17:48:33 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fA7MmKc07730; Wed, 7 Nov 2001 17:48:21 -0500 (EST) To: nickf@ontko.com cc: "Josh Berkus" , "PGSQL-SQL" Subject: Re: RIGHT JOIN is only supported with mergejoinable join conditions In-reply-to: References: Comments: In-reply-to "Nick Fankhauser" message dated "Wed, 07 Nov 2001 17:22:13 -0500" Date: Wed, 07 Nov 2001 17:48:20 -0500 Message-ID: <7727.1005173300@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200111/116 X-Sequence-Number: 5500 "Nick Fankhauser" writes: > I agree that this still may be a bug. It definitely is a bug --- we fixed a similar problem around 7.1.1 or so, but this test case appears to expose a different variant of the mistake. (The planner is generating a plan that the executor can't handle; it's supposed to know not to do that.) I think I know where to fix it, but am not confident enough in my powers of analysis today to want to actually commit anything. (I've had a bad head-cold all week and am still unable to do anything that requires more than a few minutes of sustained thought :-() Will get back on it as soon as I feel better... regards, tom lane