Request a Demo
Home   >   mailing lists

Re: [PATCH] Add regression test for aggregate NULL behavior - Mailing list pgsql-hackers

From Ashutosh Bapat
Subject Re: [PATCH] Add regression test for aggregate NULL behavior
Date
Msg-id CAExHW5tJ25ouXcCwTab1Bs8edYO7WBTO=hp-piveGk86ezJWSg@mail.gmail.com
Whole thread Raw
In response to [PATCH] Add regression test for aggregate NULL behavior  (kateriny bispo <katerinybispo06@gmail.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Replace is_publishable_class() with relispublishable column in pg_class
Next
From: Pavel Stehule
Date:
Subject: Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE