Обсуждение: pgsql: Repair bug in 8.2's new logic for planning outer joins: we have
pgsql: Repair bug in 8.2's new logic for planning outer joins: we have
От
tgl@postgresql.org (Tom Lane)
Дата:
Log Message: ----------- Repair bug in 8.2's new logic for planning outer joins: we have to allow joins that overlap an outer join's min_righthand but aren't fully contained in it, to support joining within the RHS after having performed an outer join that can commute with this one. Aside from the direct fix in make_join_rel(), fix has_join_restriction() and GEQO's desirable_join() to consider this possibility. Per report from Ian Harding. Tags: ---- REL8_2_STABLE Modified Files: -------------- pgsql/src/backend/optimizer: README (r1.35 -> r1.35.2.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/README.diff?r1=1.35&r2=1.35.2.1) pgsql/src/backend/optimizer/geqo: geqo_eval.c (r1.81.2.1 -> r1.81.2.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/geqo/geqo_eval.c.diff?r1=1.81.2.1&r2=1.81.2.2) pgsql/src/backend/optimizer/path: joinrels.c (r1.81.2.1 -> r1.81.2.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/joinrels.c.diff?r1=1.81.2.1&r2=1.81.2.2) pgsql/src/backend/optimizer/plan: initsplan.c (r1.123.2.2 -> r1.123.2.3) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/initsplan.c.diff?r1=1.123.2.2&r2=1.123.2.3)