| 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: | Whole Thread | Raw Message | 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 |