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

BUG #4926: too few pathkeys for mergeclauses

From: "Roman Kononov" <kononov(at)ftml(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4926: too few pathkeys for mergeclauses
Date: 2009-07-16 20:07:22
Message-ID: 200907162007.n6GK7MRD052680@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4926
Logged by:          Roman Kononov
Email address:      kononov(at)ftml(dot)net
PostgreSQL version: 8.4.0
Operating system:   Linux x86_64
Description:        too few pathkeys for mergeclauses
Details: 

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
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)=y;
 i | x | y
---+---+---
(0 rows)

I think, the first query should be handled the same way second is.

Responses

pgsql-bugs by date

Next:From: Greg StarkDate: 2009-07-16 20:27:47
Subject: Re: BUG #4926: too few pathkeys for mergeclauses
Previous:From: Frank van VugtDate: 2009-07-16 19:42:12
Subject: Re: bug or simply not enough stack space?

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