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

There is a doubt of fatal bug on PostgreSQL 8.0.4.

From: "Kasahara Kenichi" <kenjpm90(at)hotmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: There is a doubt of fatal bug on PostgreSQL 8.0.4.
Date: 2005-12-08 04:35:34
Message-ID: BAY102-F18488BF4710A2443AD6E05D1420@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-bugs
There is a doubt of fatal bug on PostgreSQL 8.0.4.

I found this problem when I developed a system 3 days ago.
I examine some version.
It has no problem on version 8.0.3 and on 8.1.0.
It occured only on 8.0.4 and 2 byte character.

Our development environment is
Server OS: Red Hat Enterprise Linux ES 3
DB : PostgreSQL 8.0.4
both encodes are EUC_JP

This is a test order.

1. Create the table for test.
CREATE TABLE TEST (
    ID    VARCHAR(1)
   ,NAME  VARCHAR(40)
   ,PRIMARY KEY (ID)
)

2. Make some records on the table.
INSERT INTO TEST VALUES ('1', 'あああ');
INSERT INTO TEST VALUES ('2', 'いいい');
INSERT INTO TEST VALUES ('3', 'あ');

* Please make at least two records of the same number of characters and two 
byte character. 

3. Query this table by name.
SELECT * FROM TEST
WHERE NAME = 'あああ'

The results are 'あああ' and 'いいい'.
It should be only 'あああ'.

When you also query "WHERE NAME = 'ううう'", it'll reply the same result.
It should be no result.

Please examine and fix it.
I'm waiting for the version 8.0.5. Or I'll change version 8.1.0.

Sincerely.

_________________________________________________________________
MSN Hotmail が贈る Hot Xmas × VOGUE 
http://promotion.msn.co.jp/hotmail/xmas/index.html 素敵なクリスマスコフレを
プレゼント


Responses

pgsql-bugs by date

Next:From: Gerd WilkeDate: 2005-12-08 08:57:27
Subject: BUG #2098: How to configure BDE?
Previous:From: Nicolas BarbierDate: 2005-12-07 21:09:09
Subject: Re: [PATCHES] Patch to allow contrib/pgbench files to have blank lines

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