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