Postgres Pro
Downloads
Home   >   mailing lists

Re: Wrong results with grouping sets - Mailing list pgsql-hackers

From Richard Guo
Subject Re: Wrong results with grouping sets
Date
Msg-id CAMbWs48f111ufLcTwtc22UGwFs8BLSfPtEdiVi+pYS9RzjxA-w@mail.gmail.com
Whole thread Raw
In response to Wrong results with grouping sets  (Richard Guo <guofenglinux@gmail.com>)
List pgsql-hackers
Tree view 
On Thu, Oct 10, 2024 at 6:51 PM Richard Guo <guofenglinux@gmail.com> wrote:
> On Thu, Oct 10, 2024 at 4:06 PM Richard Guo <guofenglinux@gmail.com> wrote:
> > While we can fix this issue by propagating the hasGroupRTE mark from
> > the EXISTS subquery to the parent, a better fix might be to remove the
> > subquery's RTE_GROUP entry, since we have dropped the subquery's
> > groupClause before the pull-up (see simplify_EXISTS_query).
>
> Here is the patch.

I've pushed this patch with minor tweaks.  Thanks again for the
report!

Thanks
Richard

pgsql-hackers by date:

Previous
From: Melanie Plageman
Date:
Subject: Docs Build in CI failing with "failed to load external entity"
Next
From: David Rowley
Date:
Subject: Re: Changing the default random_page_cost value