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
