projects / users / rhaas / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: c3652cd) | patch
Handle SubPlan cases in find_nonnullable_rels/vars.
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 5 Nov 2022 19:24:36 +0000 (15:24 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 5 Nov 2022 19:24:36 +0000 (15:24 -0400)
commitff8fa0bf7eb9001f321c2af4bbe9c0f2bd5c1bf8
tree7cadb5dc4c18bee125ac600864bf7c2c5bbd9fa5tree
parentc3652cd84ac8aa60dd09a9743d4db6f20e985a2fcommit | diff
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=Pihw2w@mail.gmail.com
src/backend/optimizer/util/clauses.c diff | blob | blame | history
src/test/regress/expected/join.out diff | blob | blame | history
src/test/regress/sql/join.sql diff | blob | blame | history
Robert Haas's development tree.