| From: | Richard Guo <guofenglinux(at)gmail(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PG 18 release notes draft committed |
| Date: | 2025-05-08 10:46:11 |
| Message-ID: | CAMbWs49JN6Ae3peuLkBn_CUhiEAtV9Xx0ksuYc4xG4J-2X8GNQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, May 8, 2025 at 5:41 AM Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> On Wed, May 7, 2025 at 03:03:32PM +0900, Richard Guo wrote:
> > 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.
I'm not sure whether it's appropriate to put the incorrect-result
fixes under the item "Allow some HAVING clauses on GROUPING SETS to
be pushed to WHERE clauses", since that item is an optimization and
does not fix these incorrect-result issues.
But I'm also unsure where else they should go. Would it make sense to
list them as a new item instead?
Thanks
Richard
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Gustafsson | 2025-05-08 11:20:06 | Re: disabled SSL log_like tests |
| Previous Message | Zhijie Hou (Fujitsu) | 2025-05-08 10:04:27 | RE: Fix slot synchronization with two_phase decoding enabled |