Re: contrib/levenshtein() has a bug?

Поиск
Список
Период
Сортировка
От Ben
Тема Re: contrib/levenshtein() has a bug?
Дата
Msg-id Pine.LNX.4.64.0609281421510.21293@GRD.cube42.tai.silentmedia.com
обсуждение исходный текст
Ответ на Re: contrib/levenshtein() has a bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Ah, yes, you are correct.

Hm, it's too bad levenshtein() is ascii-only.

On Thu, 28 Sep 2006, Tom Lane wrote:

> Ben <bench@silentmedia.com> writes:
>> The levenshtein function from contrib/fuzzystrmatch.sql has a max arg
>> length of 255. OK, that's cool. But check this out:
>
>> mbrainz_db=> select max(length(name)) from public.track;
>>   max
>> -----
>>   255
>> (1 row)
>
>> mbrainz_db=> select levenshtein(name,'foo') from public.track;
>> ERROR:  argument exceeds max length: 255
>
>> That seems odd.
>
> length() measures in characters whereas the limit in question is being
> enforced in bytes.  You got any multibyte characters in there?
>
> (It looks to me like levenshtein() is utterly non-multibyte-aware,
> which is probably a bug in itself.)
>
>             regards, tom lane
>

В списке pgsql-general по дате отправления:

Предыдущее
От: Geoffrey
Дата:
Сообщение: Re: continued segmentation fault
Следующее
От: "Jack Orenstein"
Дата:
Сообщение: Row versions and indexes