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
Re: BUG #4926: too few pathkeys for mergeclauses |
Список | 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 по дате отправления: