Re: Wrong results with grouping sets

[Richard Guo]

On Thu, Oct 10, 2024 at 4:06 PM Richard Guo <guofengli...@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.

Thanks
Richard

v1-0001-Remove-the-RTE_GROUP-RTE-if-we-drop-the-groupClause.patch
Description: Binary data