Re: Wrong results with grouping sets

Andrey Borodin <x4mmm@yandex-team.ru>

From: "Andrey M. Borodin" <x4mmm@yandex-team.ru>

To: vignesh C <vignesh21@gmail.com>

Cc: Richard Guo <guofenglinux@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>

Date: 2024-03-31T09:02:42Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Remove the RTE_GROUP RTE if we drop the groupClause
- ffe12d1d22e7 18.0 landed
Mark expressions nullable by grouping sets
- f5050f795aea 18.0 landed
Introduce an RTE for the grouping step
- 247dea89f761 18.0 landed

> On 11 Jan 2024, at 20:10, vignesh C <vignesh21@gmail.com> wrote:
> 
> I have changed the status of the patch to "Waiting on Author" as Tom
> Lane's comments have not yet been addressed, feel free to address them
> and update the commitfest entry accordingly.

This CF entry seems to be a fix for actually unexpected behaviour. But seems like we need another fix.
Richard, Alena, what do you think? Should we mark CF entry [0] "RwF" or leave it to wait for better fix?

Best regards, Andrey Borodin.

[0] https://commitfest.postgresql.org/47/4583/