BUG #15795: ERROR: could not find pathkey item to sort

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15795: ERROR: could not find pathkey item to sort
Дата
Msg-id 15795-fadb56c8e44ee73c@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15795: ERROR: could not find pathkey item to sort  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: BUG #15795: ERROR: could not find pathkey item to sort  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15795
Logged by:          Suresh Kumar R
Email address:      suresh.arsenal29@gmail.com
PostgreSQL version: 10.3
Operating system:   Ubuntu 16.04
Description:

I have a table 'person' with properties _id, _actual_type_name and name when
I tried the below query, I got an error saying 'could not find pathkey item
to sort'.

Here is query:
SELECT  DISTINCT  A._id0 as _id0, A._actual_type_name0 as _actual_type_name0
 FROM  ( (   SELECT  DISTINCT _id as _id0, _actual_type_name as
_actual_type_name0, name as name0  FROM  hello_world.person  ) union all  (
SELECT  DISTINCT  _id as _id0, _actual_type_name as _actual_type_name0, name
as name0  FROM  hello_world.person)) as A WHERE ( A.name0  =  A.name0 );


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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: BUG #15793: Required Community Version Installs not thecustomized EnterpriseDB one.
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #15795: ERROR: could not find pathkey item to sort