Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master

From: 邱宇航 <iamqyh(at)gmail(dot)com>
To: David Rowley <dgrowleyml(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master
Date: 2025-09-23 12:26:40
Message-ID: 352D4EB3-DE3C-48D4-A244-75F0F8785465@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 2025年9月23日 15:38,David Rowley <dgrowleyml(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2025-09-23 12:33:58 Re: Report reorder buffer size
Previous Message Ashutosh Bapat 2025-09-23 12:15:19 Re: Report reorder buffer size