Re: ERROR: failed to assign all NestLoopParams to plan nodes

On Tue, Oct 13, 2026 at 7:05 PM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> The simplest fix I can think of is to also count the outer joins that
> the outer rels in scope have already computed as req_outer in
> create_nestloop_plan(), though this is another band-aid here. See
> 0001.

Pushed and back-patched to v18. v16 and v17 have the same bug, but
the fix there would have to be a new join-order restriction in
have_dangerous_phv(), since they can't compute the PHV in the
nestloop's outer side. A simple version of that changed plans that
work fine today, and I don't think a failure this rare is worth that
risk in the stable branches. So I left them alone. If someone hits
it there, we can revisit.

> The attached 0002 does that. It's not a bug fix, so it's for master
> only.

Pushed to master.

- Richard