Re: BUG #4926: too few pathkeys for mergeclauses - Mailing list pgsql-bugs

From Greg Stark
Subject Re: BUG #4926: too few pathkeys for mergeclauses
Date
Msg-id 407d949e0907161327v7d0170c9g36adc011787574a6@mail.gmail.com
Whole thread Raw
In response to BUG #4926: too few pathkeys for mergeclauses  ("Roman Kononov" <kononov@ftml.net>)
Responses Re: BUG #4926: too few pathkeys for mergeclauses
List pgsql-bugs
On Thu, Jul 16, 2009 at 9:07 PM, Roman Kononov<kononov@ftml.net> wrote:
>
> test=3D# create table junk(i int);
> CREATE TABLE
> test=3D# select * from junk left outer join (select coalesce(i,1) as x,
> coalesce(i,2) as y from junk) t on coalesce(i,3)=3Dx and coalesce(i,4)=3D=
y and
> coalesce(i,5)=3Dx;
> ERROR: =A0too few pathkeys for mergeclauses

Thanks for the bug report. That's definitely not supposed to be
happening. It's always nice when it's easy to reproduce the problem
like this.

--=20
greg
http://mit.edu/~gsstark/resume.pdf

pgsql-bugs by date:

Previous
From: Frank Spies
Date:
Subject: Re: BUG #4918: Weird input syntax for intervals
Next
From: "Juan C. Aragon"
Date:
Subject: WARNING: out of shared memory