Skip site navigation (1) Skip section navigation (2)

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

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server/src backend/optimizer/plan/create ...
Date: 2004-01-18 00:50:03
Message-ID: 20040118005003.2FA3BD1DAB1@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
CVSROOT:	/cvsroot
Module name:	pgsql-server
Changes by:	tgl(at)svr1(dot)postgresql(dot)org	04/01/17 20:50:03

Modified files:
	src/backend/optimizer/plan: createplan.c planner.c 
	src/backend/optimizer/prep: prepunion.c 
	src/include/optimizer: planmain.h 

Log message:
	When testing whether a sub-plan can do projection, use a general-purpose
	check instead of hardwiring assumptions that only certain plan node types
	can appear at the places where we are testing.  This was always a pretty
	fragile assumption, and it turns out to be broken in 7.4 for certain cases
	involving IN-subselect tests that need type coercion.
	Also, modify code that builds finished Plan tree so that node types that
	don't do projection always copy their input node's targetlist, rather than
	having the tlist passed in from the caller.  The old method makes it too
	easy to write broken code that thinks it can modify the tlist when it
	cannot.


pgsql-committers by date

Next:From: Tom LaneDate: 2004-01-18 02:15:29
Subject: pgsql-server/src/backend/commands copy.c
Previous:From: Tom LaneDate: 2004-01-18 00:31:53
Subject: pgsql-server/src/backend/optimizer/plan Tag: R ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group