Re: Boyer-More-Horspool searching LIKE queries

2022-01-14 Thread Atsushi Ogawa
Thanks for the comments. > > The conditions under which B-M-H can be used are as follows. > > > > (1) B-M-H in LIKE search supports only single-byte character sets and UTF8. > > Multibyte character sets does not support, because it may contain another > > characters in the byte sequence. For

Re: Boyer-More-Horspool searching LIKE queries

2022-01-11 Thread Heikki Linnakangas
On 11/01/2022 15:55, Atsushi Ogawa wrote: I have created a patch to enable the Boyer-More-Horspool search algorithm (B-M-H) for LIKE queries. Cool! The conditions under which B-M-H can be used are as follows. (1) B-M-H in LIKE search supports only single-byte character sets and UTF8.

Boyer-More-Horspool searching LIKE queries

2022-01-11 Thread Atsushi Ogawa
I have created a patch to enable the Boyer-More-Horspool search algorithm (B-M-H) for LIKE queries. B-M-H needs to initialize the skip table and keep it during SQL execution. In this patch, flinfo->fn_extra is used to keep the skip table. The conditions under which B-M-H can be used are as