Sandor, Vig (sandor(dot)vig(at)audi(dot)hu) reports a bug with a severity of 1
The lower the number the more severe it is.
Bug in order by clausule
I have made a table with a TableID called "mit_id" character(16) This column is filled as follows:
row 0: 0000000000000000
row 1: 0000000000000001
row 10: 0000000000000000A
row 35: 0000000000000000Z
row 36: 00000000000000010
row 37: 00000000000000011
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:
(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...
No file was uploaded with this report
pgsql-bugs by date
|Next:||From: pgsql-bugs||Date: 2001-11-23 10:24:10|
|Subject: Bug #520: Bug in order by clausule part II|
|Previous:||From: Peter Eisentraut||Date: 2001-11-22 17:21:17|
|Subject: Re: [BUGS] Bug #513: union all changes char(3) column definition |