BUG #1345: pgsql character comparison bug

Started by PostgreSQL Bugs Listover 21 years ago2 messagesbugs
Jump to latest
#1PostgreSQL Bugs List
pgsql-bugs@postgresql.org

The following bug has been logged online:

Bug reference: 1345
Logged by: Sir Ki-Sirk

Email address: akbarofmg@empal.com

PostgreSQL version: 8.0 Beta

Operating system: WINDOW 2003 Enterprise

Description: pgsql character comparison bug

Details:

I am a C++ and pgsql beginner.
When using PostgreSQL 8.0.0 Beta 5 in Window-2003-Enterprise
I find that PostgreSQL 8.0.0 Beta 5 has simple-character-comparison-bug

see below;

QUERY=

select
chr(8) <chr(9) AS A1,
chr(9) <chr(10) AS A2,
chr(10)<chr(11) AS A3,
chr(11)<chr(12) AS A4,
chr(12)<chr(13) AS A5,
chr(13)<chr(14) AS A6,
chr(14)<chr(15) AS A7,
chr(15)<chr(16) AS A8,
chr(16)<chr(17) AS A9;

Exec --->

a1 | a2 | a3 | a4 | a5 | a6 | a7 | a8 | a9
----+----+----+----+----+----+----+----+---
t | t | t | t | t | f | t | t | t
(1 row)

Oh! the value of a6 field is "f" !!!

Please Fix this BUG

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PostgreSQL Bugs List (#1)
Re: BUG #1345: pgsql character comparison bug

"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:

select
chr(13)<chr(14) AS A6,

Oh! the value of a6 field is "f" !!!

Works fine for me. Check your locale setting.

regards, tom lane