]> granicus.if.org Git - postgresql/commit
Support FULL JOIN with no join clauses, such as X FULL JOIN Y ON TRUE.
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 6 Apr 2004 18:46:03 +0000 (18:46 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 6 Apr 2004 18:46:03 +0000 (18:46 +0000)
commite5170860eeaf28802375d0e1d51689b491958571
treebab1b8aa7cc30664251fb857aec8a3926f8d59a9
parent2098ec6e3731326e689fcd5ecfbdd536b2e16ab3
Support FULL JOIN with no join clauses, such as X FULL JOIN Y ON TRUE.
That particular corner case is not exactly compelling, but given 7.4's
ability to discard redundant join clauses, it is possible for the situation
to arise from queries that are not so obviously silly.  Per bug report
of 6-Apr-04.
src/backend/optimizer/path/costsize.c
src/backend/optimizer/path/joinpath.c