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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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