| From: | Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> |
|---|---|
| To: | kateriny bispo <katerinybispo06(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [PATCH] Add regression test for aggregate NULL behavior |
| Date: | 2025-12-17 15:31:04 |
| Message-ID: | CAExHW5tJ25ouXcCwTab1Bs8edYO7WBTO=hp-piveGk86ezJWSg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Kateriny,
On Tue, Dec 16, 2025 at 6:21 PM kateriny bispo
<katerinybispo06(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2025-12-17 15:33:16 | Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE |
| Previous Message | Peter Eisentraut | 2025-12-17 15:29:56 | Re: Replace is_publishable_class() with relispublishable column in pg_class |