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

Re: Bug #520: Bug in order by clausule part II

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: sandor(dot)vig(at)audi(dot)hu
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #520: Bug in order by clausule part II
Date: 2001-11-23 14:22:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
On Fri, 2001-11-23 at 11:24, pgsql-bugs(at)postgresql(dot)org wrote:
> now the sql command: select mit_id from table order by mit_id
> should select all rows odered as the ABC. f.e.:123456789ABCD...QRST....etc.
> At the range of 00000000000000C0...00000000000000CZ it goes creazy:
> ....
>  00000000000000CP
>  00000000000000CQ
>  00000000000000CR
>  00000000000000CT
>  00000000000000CU
>  00000000000000CV
>  00000000000000CW
>  00000000000000CX
>  00000000000000CY
>  00000000000000CS
>  00000000000000CZ
>  00000000000000D0
> ...
> (The CS value after the CY?????) Before, and after it goes "normal", only at this
> interval goes mad. I've tried Postgresql 7.0, and 7.1.3 the bug still exist under Red Hat 7.1 in two different machines. I've tested under cygwin, there is NO SUCH BUG!
> At request I can send you the Database backup... 

recreating the index on mit_id could help.

Markus Bertheau

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-11-23 16:29:31
Subject: Re: Bug #519: Bug in order by clausule
Previous:From: pgsql-bugsDate: 2001-11-23 10:24:10
Subject: Bug #520: Bug in order by clausule part II

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