]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix planner to do the right thing when a degenerate outer join (one whose
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 12 Dec 2006 21:31:09 +0000 (21:31 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 12 Dec 2006 21:31:09 +0000 (21:31 +0000)
commitbef92dadb0b18ecb04dd79bc8faf4dbccfc4dc1d
tree895b891533761d9852919019adf763981378e497
parente1b09b59ded4103eef413a743aa5e78532065dc4
Fix planner to do the right thing when a degenerate outer join (one whose
joinclause doesn't use any outer-side vars) requires a "bushy" plan to be
created.  The normal heuristic to avoid joins with no joinclause has to be
overridden in that case.  Problem is new in 8.2; before that we forced the
outer join order anyway.  Per example from Teodor.
src/backend/optimizer/geqo/geqo_eval.c
src/backend/optimizer/path/joinrels.c
src/backend/optimizer/util/joininfo.c
src/include/optimizer/joininfo.h