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

BUG #1345: pgsql character comparison bug

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1345: pgsql character comparison bug
Date: 2004-12-10 21:41:10
Message-ID: 20041210214110.EDA497385E8@www.postgresql.com (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1345
Logged by:          Sir Ki-Sirk

Email address:      akbarofmg(at)empal(dot)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


Responses

pgsql-bugs by date

Next:From: Matthew T. O'ConnorDate: 2004-12-10 22:42:24
Subject: Re: pg_autovacuum fails to run as a windows service (beta4)
Previous:From: LibsisDate: 2004-12-10 20:30:14
Subject: create/drop table bug

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