Re: Wrong results with subquery pullup and grouping sets - Mailing list pgsql-hackers

From Richard Guo
Subject Re: Wrong results with subquery pullup and grouping sets
Date
Msg-id CAMbWs494c0t2L=gmE9M_y4st6bg+MDZa4w3mVB9EeUc8cVRF2Q@mail.gmail.com
Whole thread Raw
In response to Re: Wrong results with subquery pullup and grouping sets  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List pgsql-hackers
On Wed, Mar 12, 2025 at 6:29 PM Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
> On Wed, 12 Mar 2025 at 07:45, Richard Guo <guofenglinux@gmail.com> wrote:
> > For backpatching, 0001 seems more like a cosmetic change, and I don't
> > think it needs to be backpatched.  0002 is a bug fix, but I'm not
> > confident enough to commit it to the back branches.  Given that there
> > are other wrong result issues with grouping sets fixed in version 18
> > but not in earlier versions, and that there are no field reports about
> > this issue, perhaps it's OK to refrain from backpatching this one?

> Yes, I was thinking along the same lines. This particular issue feels
> a bit manufactured, and unlikely to occur in practice, but I'm happy
> to go with whatever you decide.

Thank you, Dean.  I've decided to refrain from backpatching and have
pushed the changes to the master branch.  If we receive any complaints
from the fields in the future, we can always perform the backpatching
at that time.  Hopefully, by then, this patch will have gone through a
full beta test cycle.

Thanks
Richard



pgsql-hackers by date:

Previous
From: Oliver Ford
Date:
Subject: Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options
Next
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: long-standing data loss bug in initial sync of logical replication