Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group