OSDN Git Service

Fix thinko in new logic about pushing down non-nullability constraints:
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 10 Feb 2003 17:08:50 +0000 (17:08 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 10 Feb 2003 17:08:50 +0000 (17:08 +0000)
commit8a4fdce9f277fe1f02654091e89e96180af9c4cb
treed55143b4f8782ad8f710573191ce50a688d1e1bd
parentec8f0e82ef63927e48615b2684258eb8ce84c599
Fix thinko in new logic about pushing down non-nullability constraints:
constraints appearing in outer-join qualification clauses are restricted
as to when and where they can be pushed down.  Add regression test
to catch future errors in this area.
src/backend/optimizer/prep/prepjointree.c
src/test/regress/expected/join.out
src/test/regress/sql/join.sql