On Thu, Oct 10, 2024 at 6:51 PM Richard Guo <guofengli...@gmail.com> wrote: > 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.
I've pushed this patch with minor tweaks. Thanks again for the report! Thanks Richard