]> granicus.if.org Git - postgresql/commit
Add support for doing FULL JOIN ON FALSE. While this is really a rather
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 5 Jan 2010 23:25:44 +0000 (23:25 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 5 Jan 2010 23:25:44 +0000 (23:25 +0000)
commitc5afcf904048d83690958f9a059e4444e6e3a3ec
treec47463fd57171fcd2a03e5894a55af78b713e5f2
parent1c0f0d99ae14428bc6060241f4511eb9446288d0
Add support for doing FULL JOIN ON FALSE.  While this is really a rather
peculiar variant of UNION ALL, and so wouldn't likely get written directly
as-is, it's possible for it to arise as a result of simplification of
less-obviously-silly queries.  In particular, now that we can do flattening
of subqueries that have constant outputs and are underneath an outer join,
it's possible for the case to result from simplification of queries of the
type exhibited in bug #5263.  Back-patch to 8.4 to avoid a functionality
regression for this type of query.
src/backend/executor/nodeMergejoin.c
src/backend/optimizer/path/joinpath.c
src/include/nodes/execnodes.h
src/test/regress/expected/join.out
src/test/regress/sql/join.sql