Bug #738: "order by" returning different results in 7.2 and 7.21

Kareem Badr (kbadr(at)journyx(dot)com) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
"order by" returning different results in 7.2 and 7.21

Long Description
When doing a query that uses the "order by" command, version 7.2 and version 7.21 return the records in a different order. All of the locale environment variables are identical, and the query is identical. Here is the comparison:

bash-2.05$ hostname
demo02.journyx.com
bash-2.05$ locale
LANG=en_US
LC_CTYPE="en_US"
LC_NUMERIC="en_US"
LC_TIME="en_US"
LC_COLLATE="en_US"
LC_MONETARY="en_US"
LC_MESSAGES="en_US"
LC_PAPER="en_US"
LC_NAME="en_US"
LC_ADDRESS="en_US"
LC_TELEPHONE="en_US"
LC_MEASUREMENT="en_US"
LC_IDENTIFICATION="en_US"
LC_ALL=
bash-2.05$ psql --version
psql (PostgreSQL) 7.2
contains support for: readline, history, multibyte
Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
Portions Copyright (c) 1996, Regents of the University of California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.

id_user | pname
---------------+-----------------
amber | User
Appenzeller_K | User
bbunny | User
Birdzell_D | User
brad | User
Bradshaw_P | User
Brundage_C | User
Chen_A | User
Childs_D | User
Cooney_A | User

bash-2.04$ hostname
dev2.int.journyx.com
bash-2.04$ locale
LANG=en_US
LC_CTYPE="en_US"
LC_NUMERIC="en_US"
LC_TIME="en_US"
LC_COLLATE="en_US"
LC_MONETARY="en_US"
LC_MESSAGES="en_US"
LC_PAPER="en_US"
LC_NAME="en_US"
LC_ADDRESS="en_US"
LC_TELEPHONE="en_US"
LC_MEASUREMENT="en_US"
LC_IDENTIFICATION="en_US"
LC_ALL=
bash-2.04$ psql --version
psql (PostgreSQL) 7.2.1
Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
Portions Copyright (c) 1996, Regents of the University of California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.

id_user | pname
---------------+-----------------
Appenzeller_K | User
Birdzell_D | User
Bradshaw_P | User
Brundage_C | User
Chen_A | User
Childs_D | User
Cooney_A | User
amber | User
bbunny | User
brad | User

Sample Code

No file was uploaded with this report