From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Bug in ILIKE? |
Date: | 2008-09-26 23:30:21 |
Message-ID: | 48DD708D.6070508@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
> Andrew Dunstan <andrew(at)dunslane(dot)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.
>
>
>
I'll have another look. What happens in that case though if you have
escape+x where x is a multibyte char?
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-09-26 23:39:04 | Re: Bug in ILIKE? |
Previous Message | Abhijit Menon-Sen | 2008-09-26 23:14:15 | Re: [PATCH] allow has_table_privilege(..., 'usage') on sequences |