Prevent generation of invalid plans for RIGHT or FULL joins with multiple
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 15 Apr 2001 00:48:17 +0000 (00:48 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 15 Apr 2001 00:48:17 +0000 (00:48 +0000)
commitf9094c44c0961739aab3e3cf7dc994a9d37b6490
treeae8f64139140e92c20cba2b9dffe08b775448252
parent15a6cd0091455cafe5fe471f61c94b8fc4b787f9
Prevent generation of invalid plans for RIGHT or FULL joins with multiple
join clauses.  The mergejoin executor wants all the join clauses to appear
as merge quals, not as extra joinquals, for these kinds of joins.  But the
planner would consider plans in which partially-sorted input paths were
used, leading to only some of the join clauses becoming merge quals.
This is fine for inner/left joins, not fine for right/full joins.
src/backend/optimizer/path/joinpath.c