| 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: | Whole Thread | Raw Message | 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 |