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