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

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Tatsuro Yamada <yamada(dot)tatsuro(at)lab(dot)ntt(dot)co(dot)jp>
Cc: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ERROR: ORDER/GROUP BY expression not found in targetlist
Date: 2016-06-13 06:52:08
Message-ID: CAB7nPqTJQXkZ3c3tFHT7X4ahfwebZn3uKJiLagM4d1LwSKVxEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jun 13, 2016 at 2:42 PM, Tatsuro Yamada
<yamada(dot)tatsuro(at)lab(dot)ntt(dot)co(dot)jp> wrote:
> 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.

This looks like a different regression..

>>> 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

And the winner is:

04ae11f62e643e07c411c4935ea6af46cb112aa9 is the first bad commit
commit 04ae11f62e643e07c411c4935ea6af46cb112aa9
Author: Robert Haas <rhaas(at)postgresql(dot)org>
Date: Fri Jun 3 14:27:33 2016 -0400

I am adding that to the list of open items.
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2016-06-13 07:18:17 Re: ERROR: ORDER/GROUP BY expression not found in targetlist
Previous Message Michael Paquier 2016-06-13 05:50:46 Re: Confusing recovery message when target not hit