Re: Re: Bug in fulltext search in latest mysql-4.0.2 source

2002-05-21 Thread Michael Widenius
Hi! Vadim == Vadim P [EMAIL PROTECTED] writes: Vadim Sergei Golubchik wrote: rebuild your indexes (the proper way to do it is to issue REPAIR table_name USE_FRM Vadim Sergei, would ALTER TABLE.. DROP INDEX.. ADD FULLTEXT... do the same trick? Yes, this would do the same thing as REPAIR,

Re: Bug in fulltext search in latest mysql-4.0.2 source

2002-05-17 Thread Sergei Golubchik
Hi! On May 16, Jocelyn Fournier wrote: Hi, I don't understand, I modified ulong ft_min_word_len=3; in myisam/ft_static.c, and then recompiled MySQL using BUILD/compile-pentium --without-innodb script, but show variables still displays after restarting mysql : | ft_min_word_len

Re: Bug in fulltext search in latest mysql-4.0.2 source

2002-05-17 Thread Jocelyn Fournier
: Re: Bug in fulltext search in latest mysql-4.0.2 source Hi, I don't understand, I modified ulong ft_min_word_len=3; in myisam/ft_static.c, and then recompiled MySQL using BUILD/compile-pentium --without-innodb script, but show variables still displays after restarting mysql

Re: Bug in fulltext search in latest mysql-4.0.2 source

2002-05-16 Thread Sergei Golubchik
Hi! On May 15, Jocelyn Fournier wrote: A small question : I have : CANON BCI-11N Cartouche noir ( BJC-70 / BJC-80 / BN-700 ) in the field 'nom' . How could I match BCI-11N for exemple ? (BCI* return nothing :( ) Thanks, Jocelyn Actually, it's a question for [EMAIL PROTECTED],

Re: Bug in fulltext search in latest mysql-4.0.2 source

2002-05-16 Thread Vadim P.
Sergei Golubchik wrote: rebuild your indexes (the proper way to do it is to issue REPAIR table_name USE_FRM Sergei, would ALTER TABLE.. DROP INDEX.. ADD FULLTEXT... do the same trick? TIA, Vadim. /* sql, mysql to satisfy the spam police */

Re: Bug in fulltext search in latest mysql-4.0.2 source

2002-05-16 Thread Jocelyn Fournier
: Re: Bug in fulltext search in latest mysql-4.0.2 source Hi! On May 15, Jocelyn Fournier wrote: A small question : I have : CANON BCI-11N Cartouche noir ( BJC-70 / BJC-80 / BN-700 ) in the field 'nom' . How could I match BCI-11N for exemple ? (BCI* return nothing :( ) Thanks