Thread

1. [PATCH] Add regression test for aggregate NULL behavior

   kateriny bispo <katerinybispo06@gmail.com> — 2025-12-15T16:44:23Z

   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
   

2. 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