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-06-10T09:05:01Z

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

Attachments

v8-0001-Introduce-a-RTE-for-the-grouping-step.patch (application/octet-stream) patch v8-0001
v8-0002-Mark-expressions-nullable-by-grouping-sets.patch (application/octet-stream) patch v8-0002

On Wed, Jun 5, 2024 at 5:42 PM Richard Guo <guofenglinux@gmail.com> wrote:
> Hence here is the v7 patchset.  I've also added detailed commit messages
> for the two patches.

This patchset does not apply any more.  Here is a new rebase.

While at it, I added more checks for 'root->group_rtindex', and also
added a new test case to verify that we generate window_pathkeys
correctly with grouping sets.

Thanks
Richard