pgsql: Add test case showing that commit d0d44049d fixed a live bug.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add test case showing that commit d0d44049d fixed a live bug.
Date: 2024-05-18 18:26:28
Message-ID: E1s8OlI-000plh-Rg@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add test case showing that commit d0d44049d fixed a live bug.

When I committed d0d44049d (Account for optimized MinMax aggregates
during SS_finalize_plan), I didn't have a test case showing that it
was fixing any reachable bug. Here is one, based on bug #18465 from
Hal Takahara. Without the fix, all rows of the result show the same
"min" value, because the aggregate doesn't get recalculated.

Committed despite beta1 release freeze, with the concurrence of
pgsql-release.

Discussion: https://postgr.es/m/18465-2fae927718976b22@postgresql.org
Discussion: https://postgr.es/m/2391880.1689025003@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/779ac2c74bd15744aa92b588f70606a1a95256d2

Modified Files
--------------
src/test/regress/expected/aggregates.out | 31 +++++++++++++++++++++++++++++++
src/test/regress/sql/aggregates.sql | 10 ++++++++++
2 files changed, 41 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2024-05-18 18:31:52 pgsql: Account for optimized MinMax aggregates during SS_finalize_plan.
Previous Message Bruce Momjian 2024-05-18 16:50:46 pgsql: doc PG 17 relnotes: add incremental JSON parser item