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:


... 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 <t...@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.

>  commit: f721e94b5f360391fc3ffe183bf697a0441e9184

commit f721e94b5f360391fc3ffe183bf697a0441e9184
Author: Robert Haas <rh...@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.

Tatsuro Yamada
NTT OSS Center

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to