Postgres Pro
Downloads
Home   >   mailing lists

pgsql/src/backend/optimizer/plan (setrefs.c) - Mailing list pgsql-committers

From Tom Lane
Subject pgsql/src/backend/optimizer/plan (setrefs.c)
Date
Msg-id 200006042050.QAA64450@hub.org
Whole thread Raw
List pgsql-committers
Tree view 
  Date: Sunday, June  4, 2000 @ 16:50:50
Author: tgl

Update of /home/projects/pgsql/cvsroot/pgsql/src/backend/optimizer/plan
     from hub.org:/home/projects/pgsql/tmp/cvs-serv64386

Modified Files:
    setrefs.c

-----------------------------  Log Message  -----------------------------

Repair bug reported by ldm@apartia.com: Append nodes, which don't
actually use their targetlist, are given a targetlist that is just a
pointer to the first appended plan's targetlist.  This is OK, but what
is not OK is that any sub-select expressions in said tlist were being
entered in the subPlan lists of both the Append and the first appended
plan.  That led to two startup and two shutdown calls for the same
plan node at exec time, which led to crashes.  Fix is to not generate
a list of subPlans for an Append node.  Same problem and fix apply
to other node types that don't have a real, functioning targetlist:
Material, Sort, Unique, Hash.

pgsql-committers by date:

Previous
From: Bruce Momjian - CVS
Date:
Subject: pgsql/src/test/regress/expected (select_into.out)
Next
From: Tom Lane
Date:
Subject: pgsql/src/backend/commands (command.c)