Skip site navigation (1) Skip section navigation (2)

Re: Bug in ILIKE?

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 (view raw or flat)
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

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-09-26 23:39:04
Subject: Re: Bug in ILIKE?
Previous:From: Abhijit Menon-SenDate: 2008-09-26 23:14:15
Subject: Re: [PATCH] allow has_table_privilege(..., 'usage') on sequences

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group