Thread

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

Ashutosh Bapat <ashutosh.bapat.oss@gmail.com> — 2025-12-17T15:31:04Z

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