Hi,
This problem is probably due to the fact the ft_min_word_len variable is set
to 4 by default.
Try to add
set-variable = ft_min_word_len=3
in your my.cnf, and then recreate your table (or do a REPAIR TABLE test
USE_FRM).
Regards,
Jocelyn Fournier
----- Original Message -----
From: "Grzegorz Paszka" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 22, 2002 9:38 PM
Subject: Strange FULLTEXT search results in 4.0.2alpha
> I've compiled mysql 4.0.2-alpha from source.
>
> I've created table:
>
> create table test (
> id_test int4,
> body text);
>
> Next:
> create fulltext index test_body on test (body);
>
> insert into test (id_test,body) values (1,'test rpm');
> insert into test (id_test,body) values (2,'test rpm');
> insert into test (id_test,body) values (3,'test rpm');
> insert into test (id_test,body) values (4,'test rpm');
>
> And now:
> mysql> select * from test where match (body) against ('+rpm' IN BOOLEAN
MODE);
> Empty set (0.00 sec)
>
> But:
>
> mysql> select * from test where match (body) against ('+test' IN BOOLEAN
MODE);
> +---------+----------+
> | id_test | body |
> +---------+----------+
> | 1 | test rpm |
> | 2 | test rpm |
> | 3 | test rpm |
> | 4 | test rpm |
> +---------+----------+
> 4 rows in set (0.00 sec)
>
> I read http://www.mysql.com/doc/F/u/Fulltext_Fine-tuning.html and see
there :
> "... search using IN BOOLEAN MODE instead, which does not observe the 50%
threshold."
>
> This is right for "test" word but not for "rpm" word. Why ?
>
> I've done even more:
>
> insert into test (id_test,body) values (5,'test');
> insert into test (id_test,body) values (6,'test');
> insert into test (id_test,body) values (7,'test');
> insert into test (id_test,body) values (8,'test');
> insert into test (id_test,body) values (9,'test');
> insert into test (id_test,body) values (10,'test');
>
> And still:
> mysql> select * from test where match (body) against ('+rpm' IN BOOLEAN
MODE);
> Empty set (0.00 sec)
>
> Am I doing something wrong ? I checked ft_static.c file and there isn't
"rpm" word.
>
> Regards.
> --
> Grzegorz
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
