[packages/postgresql.git] / postgresql-825_planner_regression.patch

# from http://archives.postgresql.org/pgsql-bugs/2007-10/msg00180.php
diff -c -r1.123.2.7 src/backend/optimizer/plan/initsplan.c
*** src/backend/optimizer/plan/initsplan.c	4 Oct 2007 20:44:55 -0000	1.123.2.7
--- src/backend/optimizer/plan/initsplan.c	24 Oct 2007 20:34:08 -0000
***************
*** 625,630 ****
--- 625,631 ----
  		 * rel in the lower OJ's min_righthand, not its whole syn_righthand.
  		 */
  		if (bms_overlap(left_rels, otherinfo->syn_righthand) &&
+ 			bms_overlap(clause_relids, otherinfo->syn_righthand) &&
  			!bms_overlap(strict_relids, otherinfo->min_righthand))
  		{
  			min_lefthand = bms_add_members(min_lefthand,
Commit	Line	Data
273b7da3	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,