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: 407d949e0907161327v7d0170c9g36adc011787574a6@mail.gmail.com (view raw or flat)
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);
> CREATE TABLE
> 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.

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

In response to

Responses

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-2014 The PostgreSQL Global Development Group