]> granicus.if.org Git - postgresql/commit
Fix EquivalenceClass processing for nested append relations.
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 28 Mar 2014 15:50:01 +0000 (11:50 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 28 Mar 2014 15:50:01 +0000 (11:50 -0400)
commita87c729153e372f3731689a7be007bc2b53f1410
tree1fc8dfff63e7e8381aea3826e9eb840e88cd031c
parentb777be0d48a042f500cac72140ffb50392973aa2
Fix EquivalenceClass processing for nested append relations.

The original coding of EquivalenceClasses didn't foresee that appendrel
child relations might themselves be appendrels; but this is possible for
example when a UNION ALL subquery scans a table with inheritance children.
The oversight led to failure to optimize ordering-related issues very well
for the grandchild tables.  After some false starts involving explicitly
flattening the appendrel representation, we found that this could be fixed
easily by removing a few implicit assumptions about appendrel parent rels
not being children themselves.

Kyotaro Horiguchi and Tom Lane, reviewed by Noah Misch
src/backend/optimizer/path/allpaths.c
src/backend/optimizer/path/equivclass.c
src/backend/optimizer/plan/createplan.c
src/test/regress/expected/union.out
src/test/regress/sql/union.sql