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.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.

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