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

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
>