Postgres Pro
Downloads
Home   >   mailing lists

BUG #5478: ILIKE operator returns wrong result - Mailing list pgsql-bugs

From Markus
Subject BUG #5478: ILIKE operator returns wrong result
Date
Msg-id 201005280442.o4S4gu9L082557@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5478: ILIKE operator returns wrong result  (Bruce Momjian <bruce@momjian.us>)
Re: BUG #5478: ILIKE operator returns wrong result  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      5478
Logged by:          Markus
Email address:      markus.herven@outpost24.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.

pgsql-bugs by date:

Previous
From: "Matt Nourse"
Date:
Subject: BUG #5477: CREATE DOMAIN NOT NULL constraints not always enforced for INSERT with subquery
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #5478: ILIKE operator returns wrong result