Re: Bug in ILIKE? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug in ILIKE?
Date
Msg-id 427.1222469938@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug in ILIKE?  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Bug in ILIKE?  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> Tom Lane wrote:
>> I think it's just a bug in 8.3.

> Well, here's a patch that I think fixes it. If you're happy I'll apply 
> it to HEAD and 8.3.

That patch isn't gonna apply to HEAD ;-).  Also the introduction of
NextChar is simply broken, as it will skip additional bytes of a
multibyte char without having compared 'em.  All you need AFAICS is
to put TCHAR()s into the *p != *t comparison, so that it matches the
case for ordinary characters.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Bug in ILIKE?
Next
From: Abhijit Menon-Sen
Date:
Subject: Re: [PATCH] allow has_table_privilege(..., 'usage') on sequences