pgsql-server/src/backend/optimizer/plan create ...

От:

tgl@svr1.postgresql.org (Tom Lane)

Дата:

29 февраля 2004 г. в 13:36:08

CVSROOT:	/cvsroot
Module name:	pgsql-server
Changes by:	tgl@svr1.postgresql.org	04/02/29 13:36:05

Modified files:
	src/backend/optimizer/plan: createplan.c 

Log message:
	make_sort_from_pathkeys()'s method for choosing which of several
	equivalent sort expressions to use was broken: you can't just look
	at the relation membership, you have to actually grovel over the
	individual Vars in each expression.  I think this did work when it
	was written, but it was broken by subsequent optimizations that made
	join relations not propagate every single input variable upward.
	Must find the Var that got propagated, not choose one at random.
	Per bug report from Daniel O'Neill.