Re: Properly mark NULL returns in numeric aggregates

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: Properly mark NULL returns in numeric aggregates
Дата
Msg-id
20200410191404.l6bnmtxq3aelpbwz@alap3.anarazel.de
Ответ на
Список
Дерево обсуждения
Properly mark NULL returns in numeric aggregates Jesse Zhang <sbjesse@gmail.com>
Re: Properly mark NULL returns in numeric aggregates Andres Freund <andres@anarazel.de>
Re: Properly mark NULL returns in numeric aggregates Tom Lane <tgl@sss.pgh.pa.us>
Re: Properly mark NULL returns in numeric aggregates Jesse Zhang <sbjesse@gmail.com>
Re: Properly mark NULL returns in numeric aggregates Tom Lane <tgl@sss.pgh.pa.us>
Re: Properly mark NULL returns in numeric aggregates Jesse Zhang <sbjesse@gmail.com>
Re: Properly mark NULL returns in numeric aggregates Tom Lane <tgl@sss.pgh.pa.us>
Re: Properly mark NULL returns in numeric aggregates David Rowley <dgrowleyml@gmail.com>
Re: Properly mark NULL returns in numeric aggregates Tom Lane <tgl@sss.pgh.pa.us>
Re: Properly mark NULL returns in numeric aggregates David Rowley <dgrowleyml@gmail.com>
Re: Properly mark NULL returns in numeric aggregates Jesse Zhang <sbjesse@gmail.com>
Hi,

On 2020-04-09 16:22:11 -0700, Jesse Zhang wrote:
> We found that several functions -- namely numeric_combine,
> numeric_avg_combine, numeric_poly_combine, and int8_avg_combine -- are
> returning NULL without signaling the nullity of datum in fcinfo.isnull.
> This is obscured by the fact that the only functions in core (finalfunc
> for various aggregates) that those return values feed into happen to
> tolerate (or rather, not quite distinguish) zero-but-not-NULL trans
> values.

Shouldn't these just be marked as strict?

Greetings,

Andres Freund


В списке pgsql-hackers по дате отправления
От: David Steele
Дата:
От: Andres Freund
Дата:
Сообщение: Re: spin_delay() for ARM
FAQ