Re: [tgl@sss.pgh.pa.us: Re: [BUGS] ORDER BY bug in 8.1, WinXP]

Por favor verifiquen si pueden reproducir el problema en 8.1.3.

----- Forwarded message from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> -----

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
Date: Sat, 08 Apr 2006 15:13:36 -0400
Subject: Re: [BUGS] ORDER BY bug in 8.1, WinXP
X-Bogosity: Ham, tests=bogofilter, spamicity=0.000000, version=1.0.2

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

----- End forwarded message -----

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Hasta el momento la version 8.1.3 esta ordenando correctamente :

XXX=# select tablita.idDia , tablita.numHora
XXX-# from tablita
XXX-# WHERE tablita.campoA = 1 AND
XXX-# tablita.campoB =1 AND
XXX-# tablita.campoC =1 AND
XXX-# tablita.campoD =1 AND
XXX-# tablita.campoE = 1
XXX-# ORDER BY tablita.idDia , tablita.numHora;
iddia | numhora
-------+---------
1 | 1
1 | 2
1 | 3
1 | 4
1 | 5
1 | 6
1 | 7
1 | 8
2 | 1
2 | 2
2 | 3
2 | 4
2 | 5
2 | 6
2 | 7
2 | 8
3 | 1
3 | 2
3 | 3
3 | 4
3 | 5
3 | 6
3 | 7
3 | 8
4 | 1
4 | 2
4 | 3
4 | 4
4 | 5
4 | 6
4 | 7
4 | 8
5 | 1
5 | 2
5 | 3
5 | 4
5 | 5
5 | 6
5 | 7
5 | 8
(40 rows)

Paolo.

On 4/8/06, Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
> Por favor verifiquen si pueden reproducir el problema en 8.1.3.
>
> ----- Forwarded message from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> -----
>
> 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
> Date: Sat, 08 Apr 2006 15:13:36 -0400
> Subject: Re: [BUGS] ORDER BY bug in 8.1, WinXP
> X-Bogosity: Ham, tests=bogofilter, spamicity=0.000000, version=1.0.2
>
> 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
>
> ----- End forwarded message -----
>
>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>
> ---------------------------(fin del mensaje)---------------------------
> TIP 5: ¿Has leído nuestro extenso FAQ?
>
> http://www.postgresql.org/files/documentation/faqs/FAQ.html
>

Paolo Lopez escribió:
> Hasta el momento la version 8.1.3 esta ordenando correctamente :
>

>
> On 4/8/06, Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
>
>>Por favor verifiquen si pueden reproducir el problema en 8.1.3.
>>

De momento no puedo actualizar este sistema a 8.1.3, pero probaré en otro que si lo tiene, pero si
Paolo dice que ya sale bien y nadie mas se queja, es que era eso.

Y sobre todo ...

Gracias Alvaro, Tom Lane y cualquier otro que se haya preocupado, y dedicado parte de su fin de
semana, a aclarar el asunto.

Saludos,
--
*****************************************
Oswaldo Hernández
oswaldo(at)soft-com(dot)es
*****************************************