Re: ERROR: ORDER/GROUP BY expression not found in targetlist

Hi,

>>> Subject: Re: [HACKERS] ORDER/GROUP BY expression not found in targetlist
>>> Date: Thu, 09 Jun 2016 12:08:01 +0900
>
> Right, I saw that thread which involved the same error message:
>
>
https://www.postgresql.org/message-id/flat/20160526021235.w4nq7k3gnheg7vit%40alap3.anarazel.de#20160526021235.w4nq7k3gnheg7vit@alap3.anarazel.de
>
> ... but that seems to be a different problem than the one you and I
> have seen, it involved repeated references to columns in the tlist.
> It was fixed with this commit:
>
> commit aeb9ae6457865c8949641d71a9523374d843a418
> Author: Tom Lane <tgl@sss.pgh.pa.us>
> Date:   Thu May 26 14:52:24 2016 -0400
>
>      Disable physical tlist if any Var would need multiple sortgroupref labels.

I use this version:f721e94 to run tpc-h on last week.
This patch is commited at Jun 8. If it fixed, I didn't get the error.
>PG96beta1>  commit: f721e94b5f360391fc3ffe183bf697a0441e9184

-----
commit f721e94b5f360391fc3ffe183bf697a0441e9184
Author: Robert Haas <rhaas@postgresql.org>
Date:   Wed Jun 8 08:37:06 2016 -0400
    Fix typo.
    Amit Langote
-----

I got mistake to write an e-mail to -hackers on last week. :-<
I should have written this.
  The bug has not fixed by Tom Lane's patch: commit aeb9ae6.  Because I got the same error using tpc-h.


>> Today, I try it again by changing max_parallel_workers_per_gather parameter.
>> The result of Q1 is bellow. Is this bug in the Open items on wiki?
>
> I don't see it on the Open Issues list.

I checked the list, but the bug is not listed.  https://wiki.postgresql.org/wiki/PostgreSQL_9.6_Open_Items


Regards,
Tatsuro Yamada
NTT OSS Center