Re: Properly mark NULL returns in numeric aggregates

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Properly mark NULL returns in numeric aggregates
Дата
Msg-id 31733.1586549996@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Properly mark NULL returns in numeric aggregates  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> 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?

No, certainly not --- they need to be able to act on null inputs.
The question is how careful do we need to be about representing
null results as "real" nulls rather than NULL pointers.

            regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Bossart, Nathan"
Дата:
Сообщение: pg_dump issue with renamed system schemas
Следующее
От: Tom Lane
Дата:
Сообщение: Re: spin_delay() for ARM