Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: BUG #3938: Row-wise comparison fails


  • From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, cgriffo(at)practicepartner(dot)com, pgsql-bugs(at)postgresql(dot)org
  • Subject: Re: BUG #3938: Row-wise comparison fails
  • Date: Thu, 07 Feb 2008 12:55:47 -0500
  • Message-id: <7044(dot)1202406947(at)sss(dot)pgh(dot)pa(dot)us>

I wrote:
> Weird.  I suppose I broke this in the operator-family rewrite.
> Will look.

Sigh ... I fat-fingered some loop control logic ...

Index: indxpath.c
===================================================================
RCS file: /cvsroot/pgsql/src/backend/optimizer/path/indxpath.c,v
retrieving revision 1.226
diff -c -r1.226 indxpath.c
*** indxpath.c	1 Jan 2008 19:45:50 -0000	1.226
--- indxpath.c	7 Feb 2008 17:46:10 -0000
***************
*** 2619,2627 ****
  						 op_strategy, lefttype, righttype, opfam);
  			}
  			new_ops = lappend_oid(new_ops, expr_op);
  		}
- 		lefttypes_cell = lnext(lefttypes_cell);
- 		righttypes_cell = lnext(righttypes_cell);
  	}
  
  	/* If we have more than one matching col, create a subset rowcompare */
--- 2619,2627 ----
  						 op_strategy, lefttype, righttype, opfam);
  			}
  			new_ops = lappend_oid(new_ops, expr_op);
+ 			lefttypes_cell = lnext(lefttypes_cell);
+ 			righttypes_cell = lnext(righttypes_cell);
  		}
  	}
  
  	/* If we have more than one matching col, create a subset rowcompare */


			regards, tom lane



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group