Don't pass down nonnullable_vars while reducing outer joins.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: b0b72c64a0ce7bf5dd78a80b33d85c89c943ad0d
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2022-11-05T19:58:51Z
Releases: 16.0
Don't pass down nonnullable_vars while reducing outer joins.

We weren't actually using the passed-down list for anything, other
than computing the new value to be passed down further.  I (tgl)
probably had the idea that we'd need this data eventually; but
no use-case has emerged in a good long while, so let's just stop
expending useless cycles here.

Richard Guo

Discussion: https://postgr.es/m/CAMbWs48KLy9aBb=sZ5MoNmnqAcGHaW_JTGWLCgoE_uMW7S6C-A@mail.gmail.com

Files

PathChange+/−
src/backend/optimizer/prep/prepjointree.c modified +6 −27

Discussion