Re: PG 18 release notes draft committed

On Wed, May 7, 2025 at 03:03:32PM +0900, Richard Guo wrote:
> On Fri, May 2, 2025 at 11:44 AM Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> >
> > I have committd the first draft of the PG 18 release notes.
>
> > I will continue improving it until beta 1, and until the final release.
> > I will probably add markup in 1-3 weeks. Let the feedback begin. ;-)
>
> Thanks for working on these.
>
> I'm wondering if we should consider mentioning that several
> long-standing issues related to grouping sets have been fixed starting
> from PostgreSQL v18. I understand that we typically don't include bug
> fixes in the release notes, but these particular issues have been
> present since grouping sets were first introduced, and currently they
> still exist in the back branches (yeah, for some reason we do not have
> back-branch fixes; we only fix them in v18 and going forward).
>
> There have been complaints from users about grouping sets giving
> incorrect results in certain cases, which has made them hesitant to
> use PostgreSQL for analytical workloads. Since these issues are fixed
> in v18, it might be worthwhile to point this out — if only to reassure
> users that these issues are no longer a concern going forward.
>
> (FWIW, the related commits are 247dea89f, f5050f795, and cc5d98525).

Agreed, any fix that commonly used to return wrong results should be
mentioned. Applied patch attached.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Do not let urgent matters crowd out time for investment in the future.