public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bruce Momjian <[email protected]>
To: Richard Guo <[email protected]>
Cc: PostgreSQL-development <[email protected]>
Subject: Re: PG 18 release notes draft committed
Date: Fri, 9 May 2025 14:03:10 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAMbWs4-cpM4hgfGLwt69+Bhh7zjYSRew+za4=4Vq6sAvwOg0Cw@mail.gmail.com>
References: <[email protected]>
<CAMbWs4_asKPqTCt0h9pp=zHc9vmPcnczbHeF6Xkxn1LhLapcTQ@mail.gmail.com>
<[email protected]>
<CAMbWs49JN6Ae3peuLkBn_CUhiEAtV9Xx0ksuYc4xG4J-2X8GNQ@mail.gmail.com>
<[email protected]>
<CAMbWs4-G_vn5J4u26h9J9DU4Ys_OKCRwRqtyBXnjY_P+cv2k1g@mail.gmail.com>
<CAMbWs4-cpM4hgfGLwt69+Bhh7zjYSRew+za4=4Vq6sAvwOg0Cw@mail.gmail.com>
On Fri, May 9, 2025 at 12:05:07PM +0900, Richard Guo wrote:
> > I think there are two patterns here:
> >
> > * 247dea89f and cc5d98525 fix cases where grouping expressions fail to
> > match lower-level target items due to expression preprocessing or
> > subquery pull-up. Subqueries are one example of such expressions.
> >
> > * f5050f795 fixes cases where some seemingly redundant grouping or
> > ordering expressions were incorrectly ignored, without recognizing
> > that they could be nulled by grouping sets.
> >
> > I don't think this constitutes an incompatibility, and it's unlikely
> > that anyone is relying on the old behavior, as it was clearly
> > incorrect.
> >
> > (I realize these descriptions are too technical, but I'm not sure how
> > to express them in a more user-facing way.)
>
> How about putting them this way:
>
> * 247dea89f and cc5d98525 fix queries in which GROUP BY columns
> contain expressions that are complex or originate from subqueries.
>
> * f5050f795 fixes queries in which ORDER BY columns contain
> expressions that are used in grouping sets.
Okay, that is clear. Let's stay with what we have in the release notes
and see if we get any feedback from users during the beta period; that
might give us direction on whether we want to expand what we already
have. Thanks.
--
Bruce Momjian <[email protected]> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
view thread (147+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: PG 18 release notes draft committed
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox