BUG #5478: ILIKE operator returns wrong result

From: "Markus" <markus(dot)herven(at)outpost24(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5478: ILIKE operator returns wrong result
Date: 2010-05-28 04:42:56
Message-ID: 201005280442.o4S4gu9L082557@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5478
Logged by: Markus
Email address: markus(dot)herven(at)outpost24(dot)com
PostgreSQL version: PostgreSQL 8.4.
Operating system: Ubuntu 10.04
Description: ILIKE operator returns wrong result
Details:

The following query

select 'ba' ilike '%__%';

return true as expected in 8.2 but false in 8.4.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kurt wagner 2010-05-28 09:06:05 BUG #5479: PosgreSQL Documentation does not mention OPEN
Previous Message Matt Nourse 2010-05-28 02:53:11 BUG #5477: CREATE DOMAIN NOT NULL constraints not always enforced for INSERT with subquery