Re: BUG #4926: too few pathkeys for mergeclauses

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