| From: | Richard Guo <guofenglinux(at)gmail(dot)com> |
|---|---|
| To: | Haibo Yan <tristan(dot)yim(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Thom Brown <thom(at)linux(dot)com>, Jacob Brazeal <jacob(dot)brazeal(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: remove_useless_joins vs. bug #19560 |
| Date: | 2026-09-19 01:45:47 |
| Message-ID: | CAMbWs4_syeDU0Jkc-hF5sRLXK1STztt0YmnLRXTXTtejg21Rog@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, Sep 19, 2026 at 4:22 AM Haibo Yan <tristan(dot)yim(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Naga Appani | 2026-09-19 01:56:36 | Re: 64-bit MultiXactOffset vs. 9.3->9.4 upgrade, pg_resetwal, "wraparound" msg |
| Previous Message | Atsushi Ogawa | 2026-09-19 01:12:52 | Re: [PATCH] Use Boyer-Moore-Horspool for simple LIKE contains patterns |