From: | tgl(at)postgresql(dot)org (Tom Lane) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Get rid of adjust_appendrel_attr_needed(), which has been broken |
Date: | 2008-11-11 18:13:54 |
Message-ID: | [email protected] |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Log Message:
-----------
Get rid of adjust_appendrel_attr_needed(), which has been broken ever since
we extended the appendrel mechanism to support UNION ALL optimization. The
reason nobody noticed was that we are not actually using attr_needed data for
appendrel children; hence it seems more reasonable to rip it out than fix it.
Back-patch to 8.2 because an Assert failure is possible in corner cases.
Per examination of an example from Jim Nasby.
In HEAD, also get rid of AppendRelInfo.col_mappings, which is quite inadequate
to represent UNION ALL situations; depend entirely on translated_vars instead.
Tags:
----
REL8_2_STABLE
Modified Files:
--------------
pgsql/src/backend/optimizer/path:
allpaths.c (r1.154.2.2 -> r1.154.2.3)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/allpaths.c?r1=1.154.2.2&r2=1.154.2.3)
pgsql/src/backend/optimizer/prep:
prepunion.c (r1.134.2.1 -> r1.134.2.2)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/prep/prepunion.c?r1=1.134.2.1&r2=1.134.2.2)
pgsql/src/include/optimizer:
prep.h (r1.57 -> r1.57.2.1)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/prep.h?r1=1.57&r2=1.57.2.1)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-11-11 19:05:21 | pgsql: Ensure that the phrels sets of PlaceHolderVars appearing in an |
Previous Message | Tom Lane | 2008-11-11 18:13:44 | pgsql: Get rid of adjust_appendrel_attr_needed(), which has been broken |