git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Handle SubPlan cases in find_nonnullable_rels/vars.

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

Sat, 5 Nov 2022 19:24:36 +0000 (15:24 -0400)

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

Sat, 5 Nov 2022 19:24:36 +0000 (15:24 -0400)

commit ff8fa0bf7eb9001f321c2af4bbe9c0f2bd5c1bf8

tree 7cadb5dc4c18bee125ac600864bf7c2c5bbd9fa5 tree

parent c3652cd84ac8aa60dd09a9743d4db6f20e985a2f commit | 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

This is the main PostgreSQL git repository.

RSS Atom