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, whole thread or download thread mbox)
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-2017 The PostgreSQL Global Development Group