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

Re: ORDER BY bug in 8.1, WinXP

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ORDER BY bug in 8.1, WinXP
Date: 2006-04-08 19:13:36
Message-ID: 25536.1144523616@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-es-ayuda
Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> I observe that Paolo was using 8.1.0 and Oswaldo 8.1.1.

This appears to be the same bug already fixed in 8.1.3:

2006-01-29 12:27  tgl

	* src/: backend/optimizer/path/indxpath.c,
	backend/optimizer/path/pathkeys.c, include/optimizer/paths.h
	(REL8_1_STABLE): Fix code that checks to see if an index can be
	considered to match the query's requested sort order.  It was
	assuming that build_index_pathkeys always generates a pathkey per
	index column, which was not true if implied equality deduction had
	determined that two index columns were effectively equated to each
	other.	Simplest fix seems to be to install an option that causes
	build_index_pathkeys to support this behavior as well as the
	original one.  Per report from Brian Hirt.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Paolo LopezDate: 2006-04-08 22:49:41
Subject: Re: Problema Order By en PosgreSQL 8.1
Previous:From: Alvaro HerreraDate: 2006-04-08 17:23:35
Subject: ORDER BY bug in 8.1, WinXP

pgsql-es-ayuda by date

Next:From: Ruddy VargasDate: 2006-04-08 21:09:40
Subject: Crystal report y NPGSQL
Previous:From: Alvaro HerreraDate: 2006-04-08 17:23:35
Subject: ORDER BY bug in 8.1, WinXP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group