Обсуждение: [PATCH] Add regression test for aggregate NULL behavior

Поиск
Список
Период
Сортировка

[PATCH] Add regression test for aggregate NULL behavior

От
kateriny bispo
Дата:
Hi,

This patch adds a new regression test covering the behavior of aggregate
functions when handling NULL values, including COUNT, COUNT(*) and AVG
on non-empty and empty relations.

The test was implemented using the pg_regress framework and follows the
existing regression testing conventions.

Feedback is welcome.

Best regards,
Kateriny
Вложения

Re: [PATCH] Add regression test for aggregate NULL behavior

От
Ashutosh Bapat
Дата:
Hi Kateriny,

On Tue, Dec 16, 2025 at 6:21 PM kateriny bispo
<katerinybispo06@gmail.com> wrote:
>
> Hi,
>
> This patch adds a new regression test covering the behavior of aggregate
> functions when handling NULL values, including COUNT, COUNT(*) and AVG
> on non-empty and empty relations.
>
> The test was implemented using the pg_regress framework and follows the
> existing regression testing conventions.
>
> Feedback is welcome.

These tests should go to aggregates.sql. That file already has some
tests for NULL input to aggregates. Do those cover the cases you want
to cover?

--
Best Wishes,
Ashutosh Bapat