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(dot)w4nq7k3gnheg7vit%40alap3(dot)anarazel(dot)de#20160526021235(dot)w4nq7k3gnheg7vit(at)alap3(dot)anarazel(dot)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(at)sss(dot)pgh(dot)pa(dot)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(at)postgresql(dot)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