Request a Demo
Home   >   mailing lists

Re: remove_useless_joins vs. bug #19560 - Mailing list pgsql-hackers

From Richard Guo
Subject Re: remove_useless_joins vs. bug #19560
Date
Msg-id CAMbWs4_syeDU0Jkc-hF5sRLXK1STztt0YmnLRXTXTtejg21Rog@mail.gmail.com
Whole thread
In response to Re: remove_useless_joins vs. bug #19560  (Haibo Yan <tristan.yim@gmail.com>)
List pgsql-hackers
Tree view 
On Sat, Sep 19, 2026 at 4:22 AM Haibo Yan <tristan.yim@gmail.com> wrote:
> I found what looks like a regression from e28cf96e935
> ("Fix stale copies of PHVs in subqueries").  In particular, I think there is
> still a way for an upper-level PHV containing an unprocessed SubLink to get
> into a subquery after preprocess_subquery_phvs() has already run.

This is the same bug reported by Fujii-san earlier, which is fixed in
my v1-0001-Fix-preprocessing-of-PHV-copies-pushed-down-into-.patch.

- Richard

pgsql-hackers by date:

Previous
From: Atsushi Ogawa
Date:
Subject: Re: [PATCH] Use Boyer-Moore-Horspool for simple LIKE contains patterns
Next
From: Naga Appani
Date:
Subject: Re: 64-bit MultiXactOffset vs. 9.3->9.4 upgrade, pg_resetwal, "wraparound" msg