Skip site navigation (1) Skip section navigation (2)

Re: BUG #4926: too few pathkeys for mergeclauses

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Roman Kononov <kononov(at)ftml(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4926: too few pathkeys for mergeclauses
Date: 2009-07-16 20:27:47
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
On Thu, Jul 16, 2009 at 9:07 PM, Roman Kononov<kononov(at)ftml(dot)net> wrote:
> test=# create table junk(i int);
> test=# select * from junk left outer join (select coalesce(i,1) as x,
> coalesce(i,2) as y from junk) t on coalesce(i,3)=x and coalesce(i,4)=y and
> coalesce(i,5)=x;
> ERROR:  too 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.


In response to


pgsql-bugs by date

Next:From: Juan C. AragonDate: 2009-07-16 21:41:13
Subject: WARNING: out of shared memory
Previous:From: Roman KononovDate: 2009-07-16 20:07:22
Subject: BUG #4926: too few pathkeys for mergeclauses

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group