Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #5478: ILIKE operator returns wrong result
Date
Msg-id 25312.1275057704@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5478: ILIKE operator returns wrong result  ("Markus" <markus.herven@outpost24.com>)
Responses Re: BUG #5478: ILIKE operator returns wrong result  (Bruce Momjian <bruce@momjian.us>)
List pgsql-bugs
Tree view 
"Markus" <markus.herven@outpost24.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5480: Autovacuum interferes with operations (e.g. truncate) on very large databases
Next
From: Tom Lane
Date:
Subject: Re: BUG #5477: CREATE DOMAIN NOT NULL constraints not always enforced for INSERT with subquery