Re: contrib/levenshtein() has a bug? - Mailing list pgsql-general

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