Re: BUG #4788: bug in string comparison

Gerhard Kirchmann wrote:
> 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.

Can you provide a self-contained test case? Including the table
definition for the table, the full query, results on both versions, and
if possible, the data. If you can reproduce it with a smaller table,
that's even better.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com