BUG #4926: too few pathkeys for mergeclauses

Поиск
Список
Период
Сортировка
От Roman Kononov
Тема BUG #4926: too few pathkeys for mergeclauses
Дата
Msg-id 200907162007.n6GK7MRD052680@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4926: too few pathkeys for mergeclauses  (Greg Stark <gsstark@mit.edu>)
Re: BUG #4926: too few pathkeys for mergeclauses  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4926
Logged by:          Roman Kononov
Email address:      kononov@ftml.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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Frank van Vugt
Дата:
Сообщение: Re: bug or simply not enough stack space?
Следующее
От: Frank Spies
Дата:
Сообщение: Re: BUG #4918: Weird input syntax for intervals