BUG #4788: bug in string comparison - Mailing list pgsql-bugs

From Gerhard Kirchmann
Subject BUG #4788: bug in string comparison
Date
Msg-id 200905011118.n41BI3FU045506@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4788: bug in string comparison
List pgsql-bugs
The following bug has been logged online:

Bug reference:      4788
Logged by:          Gerhard Kirchmann
Email address:      gerhard.kirchmann@arcor.de
PostgreSQL version: 8.4beta1
Operating system:   openSUSE 11.1
Description:        bug in string comparison
Details:

I have the same table in 8.3.7 and 8.4beta1 where one column (verein_id)
contains the string "56022" in 47 rows out of about 93000 rows. Under
8.4beta1 I get only 45 rows with:
where vereind_id = '56022'
 and with
where verein_id like '56022%'
I get all 47 rows.

The length of the string is always five. I work with utf-8.

pgsql-bugs by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Unable to make DBD-Pg-2.13.1
Next
From: Heikki Linnakangas
Date:
Subject: Re: BUG #4788: bug in string comparison