Allow partitionwise join to handle nested FULL JOIN USING cases.
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 8 Apr 2020 02:12:14 +0000 (22:12 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 8 Apr 2020 02:12:14 +0000 (22:12 -0400)
commit981643dcdb70b6ce70d8a08417f71f465f236cb5
treea9963feb87daf4a5796228d589bd8bc241e344ef
parentc8434d64ce03c32e0029417a82ae937f2055268f
Allow partitionwise join to handle nested FULL JOIN USING cases.

This case didn't work because columns merged by FULL JOIN USING are
represented in the parse tree by COALESCE expressions, and the logic
for recognizing a partitionable join failed to match upper-level join
clauses to such expressions.  To fix, synthesize suitable COALESCE
expressions and add them to the nullable_partexprs lists.  This is
pretty ugly and brute-force, but it gets the job done.  (I have
ambitions of rethinking the way outer-join output Vars are
represented, so maybe that will provide a cleaner solution someday.
For now, do this.)

Amit Langote, reviewed by Justin Pryzby, Richard Guo, and myself

Discussion: https://postgr.es/m/CA+HiwqG2WVUGmLJqtR0tPFhniO=H=9qQ+Z3L_ZC+Y3-EVQHFGg@mail.gmail.com
src/backend/optimizer/util/relnode.c
src/include/nodes/pathnodes.h
src/test/regress/expected/partition_join.out
src/test/regress/sql/partition_join.sql