From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | suresh(dot)arsenal29(at)gmail(dot)com |
Subject: | BUG #15795: ERROR: could not find pathkey item to sort |
Date: | 2019-05-08 06:51:32 |
Message-ID: | 15795-fadb56c8e44ee73c@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15795
Logged by: Suresh Kumar R
Email address: suresh(dot)arsenal29(at)gmail(dot)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 );
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2019-05-08 07:10:36 | Re: BUG #15795: ERROR: could not find pathkey item to sort |
Previous Message | Thomas Munro | 2019-05-08 00:17:42 | Re: BUG #15793: Required Community Version Installs not the customized EnterpriseDB one. |