Gerhard Kirchmann wrote:
The following bug has been logged online:
Bug reference: 4788
Logged by: Gerhard Kirchmann
Email address: gerhard.kirchm...@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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
