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.
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? |