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

Re: BUG #5478: ILIKE operator returns wrong result

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Markus" <markus(dot)herven(at)outpost24(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5478: ILIKE operator returns wrong result
Date: 2010-05-28 14:41:44
Message-ID: 25312.1275057704@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Markus" <markus(dot)herven(at)outpost24(dot)com> writes:
> select 'ba' ilike '%__%';
> return true as expected in 8.2 but false in 8.4.

I have a feeling that this represents still another bug in the
special-case path for % followed by _ (cf bug #4821).  If so,
maybe we ought to just toss out that optimization?

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2010-05-28 14:48:00
Subject: Re: BUG #5477: CREATE DOMAIN NOT NULL constraints not always enforced for INSERT with subquery
Previous:From: Tom LaneDate: 2010-05-28 14:13:19
Subject: Re: BUG #5480: Autovacuum interferes with operations (e.g. truncate) on very large databases

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