pgsql: Remove redundant breaks in HeapTupleSatisfiesVisibility

Remove redundant breaks in HeapTupleSatisfiesVisibility Author: Melanie Plageman Discussion: https://postgr.es/m/caakru_zjg_n7zhtwp+josy_hrce4+gkiol137y2c2en-kux...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c3652cd84ac8aa60dd09a9743d4db6f20e98

pgsql: Handle SubPlan cases in find_nonnullable_rels/vars.

Handle SubPlan cases in find_nonnullable_rels/vars. We can use some variants of SubPlan to deduce that Vars appearing in the testexpr must be non-null. Richard Guo Discussion: https://postgr.es/m/CAMbWs4-jV=199A2Y_6==99dYnpnmaO_Wz_RGkRTTaCB=pih...@mail.gmail.com Branch -- master Details -

pgsql: Don't pass down nonnullable_vars while reducing outer joins.

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 whi