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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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