Re: Wrong aggregate result when sorting by a NULL value

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ondřej Bouda <obouda(at)email(dot)cz>
Cc: Andres Freund <andres(at)anarazel(dot)de>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Wrong aggregate result when sorting by a NULL value
Date: 2018-11-02 15:34:46
Message-ID: 32176.1541172886@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I wrote:
> =?UTF-8?Q?Ond=c5=99ej_Bouda?= <obouda(at)email(dot)cz> writes:
>> the following seems as a bug to me on Postgres 11.0:

> Yeah, somebody broke this between 10.x and 11.0. ...
> I've not looked at the code yet, but it's acting like somebody changed the
> STRICT logic from "are any of the aggregate's arguments null" to "is any
> part of the whole row (including ordering values) null". Wrong ...

git bisect fingers this:

commit 69c3936a1499b772a749ae629fc59b2d72722332
Author: Andres Freund <andres(at)anarazel(dot)de>
Date: Tue Jan 9 13:25:38 2018 -0800

Expression evaluation based aggregate transition invocation.

Andres, do you have time to look at this right now?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2018-11-02 15:36:49 Re: BUG #15482: Foreign keys to a partition (NOT A PARTITIONED) break the server
Previous Message Alvaro Herrera 2018-11-02 15:10:27 Re: BUG #15482: Foreign keys to a partition (NOT A PARTITIONED) break the server