Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master - Mailing list pgsql-hackers

From 邱宇航
Subject Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master
Date
Msg-id 352D4EB3-DE3C-48D4-A244-75F0F8785465@gmail.com
Whole thread Raw
In response to Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
> 2025年9月23日 15:38,David Rowley <dgrowleyml@gmail.com> 写道:
>
> If you check the release notes and the commit message for f5050f795
> you'll see that it does mention that wrong results could be returned.
>
> What wasn't mentioned was that this wasn't fixed in prior versions.
> The reason being is that the fix required changing the query tree
> representation, which we can't change in the back branches due to
> incompatibility with stored rules in existing databases. So, a change
> in query results for certain queries here is expected.

Yeah, I got it. Thanks David and Bruce.

And what about the query 2. This is caused by another commit, and
it's not mentioned in the commit message or the mailing discussion.

Best regards,
Yuhang Qiu




pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: Report reorder buffer size
Next
From: Andres Freund
Date:
Subject: Re: Report reorder buffer size