Re: Wrong results with grouping sets

Richard Guo <guofenglinux@gmail.com>

From: Richard Guo <guofenglinux@gmail.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2024-09-10T04:04:17Z

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 Wed, Sep 4, 2024 at 9:16 AM Richard Guo <guofenglinux@gmail.com> wrote:
> I'm seeking the possibility to push 0001 and 0002 sometime this month.
> Please let me know if anyone thinks this is unreasonable.
>
> For 0003, it might be extended to remove all no-op PHVs except those
> that are serving to isolate subexpressions, not only the PHVs used to
> carry the nullingrel bit that represents the grouping step.  There is
> a separate thread for it [1].

I went ahead and pushed 0001 and 0002, and am now waiting for the
upcoming bug reports.

Thanks for all the discussions and reviews.

Thanks
Richard