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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew T. O'Connor | 2004-12-10 22:42:24 | Re: pg_autovacuum fails to run as a windows service (beta4) |
Previous Message | Libsis | 2004-12-10 20:30:14 | create/drop table bug |