postgresql-825_planner_regression.patch

   1 # from http://archives.postgresql.org/pgsql-bugs/2007-10/msg00180.php
   2 diff -c -r1.123.2.7 src/backend/optimizer/plan/initsplan.c
   3 *** src/backend/optimizer/plan/initsplan.c      4 Oct 2007 20:44:55 -0000       1.123.2.7
   4 --- src/backend/optimizer/plan/initsplan.c      24 Oct 2007 20:34:08 -0000
   5 ***************
   6 *** 625,630 ****
   7 --- 625,631 ----
   8                  * rel in the lower OJ's min_righthand, not its whole syn_righthand.
   9                  */
  10                 if (bms_overlap(left_rels, otherinfo->syn_righthand) &&
  11 +                       bms_overlap(clause_relids, otherinfo->syn_righthand) &&
  12                         !bms_overlap(strict_relids, otherinfo->min_righthand))
  13                 {
  14                         min_lefthand = bms_add_members(min_lefthand,