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 t

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

2002-05-17 Thread Jocelyn Fournier
; Sent: Thursday, May 16, 2002 1:58 PM Subject: 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,

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-16 Thread Jocelyn Fournier
TED]> Sent: Thursday, May 16, 2002 12:58 PM Subject: 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-7

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 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 PRO