git.postgresql.org Git - users/heikki/postgres.git/commit

projects / users / heikki / postgres.git / commit

summary | shortlog | log | commit | commitdiff | tree
(parent: ec8f0e8) | patch

author	Tom Lane <tgl@sss.pgh.pa.us>
	Mon, 10 Feb 2003 17:08:50 +0000 (17:08 +0000)
committer	Tom Lane <tgl@sss.pgh.pa.us>
	Mon, 10 Feb 2003 17:08:50 +0000 (17:08 +0000)
commit	8a4fdce9f277fe1f02654091e89e96180af9c4cb
tree	d55143b4f8782ad8f710573191ce50a688d1e1bd	tree
parent	ec8f0e82ef63927e48615b2684258eb8ce84c599	commit \| diff

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		diff \| blob \| blame \| history
src/test/regress/expected/join.out		diff \| blob \| blame \| history
src/test/regress/sql/join.sql		diff \| blob \| blame \| history

Heikki's random PostgreSQL patches