The following bug has been logged online:
Bug reference: 4788
Logged by: Gerhard Kirchmann
Email address: gerhard(dot)kirchmann(at)arcor(dot)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.