RE: Fulltext problem

["Rick James" <rjames@xxxxxxxxxxxxx>]

With so few rows, are you hitting the 50% rule?  Try again with a decent
number of rows. 

> -----Original Message-----
> From: devy [mailto:devyer@xxxxxxxxx] 
> Sent: Thursday, January 04, 2007 5:46 AM
> To: mysql@xxxxxxxxxxxxxxx; internals@xxxxxxxxxxxxxxx
> Subject: Fulltext problem
> 
> Hi,
> today I've experienced a problem that I don't understand and 
> I can't solve!
> 
> I've created a table as follows:
> ---------------
> CREATE TABLE `ft_test` (
> `id` int(11) NOT NULL auto_increment,
> `field1` varchar(255) NOT NULL ,
> `field2` varchar(255) NOT NULL ,
> `field3` text NOT NULL,
> PRIMARY KEY (`id`),
> FULLTEXT KEY `field1` (`field1`),
> FULLTEXT KEY `field2` (`field2`),
> FULLTEXT KEY `field3` (`field3`),
> FULLTEXT KEY `f1d2` (`field1`,`field2`)
> ) ENGINE=MyISAM CHARSET=utf8;
> -----------------
> 
> and then I've filled this table with the following statement:
> -----------------
> insert into ft_test (field1,field2,field3)
> VALUES('mysql full text', 'this is a test', 'mysql fulltext');
> -----------------
> 
> the problem is that when I execute this query I always get 0 
> as relevance:
> > select *, match(field1) against('mysql') as relevancy from ft_test;
> id field1 field2 field3 relevancy
> ------ --------------- -------------- -------------- ---------
> 1 mysql full text this is a test mysql fulltext 0
> 
> 
> I expected a value for relevancy! shouldn't I?
> I tested with all other words and combination of fulltext index:
> ---
> select *, match(field2) against('mysql') as relevancy from ft_test;
> select *, match(field3) against('mysql') as relevancy from ft_test;
> select *, match(field3) against('fulltext') as relevancy from ft_test;
> ---
> 
> but I always get 0!
> 
> This is a "show variables" of my mysql server
> Variable_name Value
> ------------------------ --------------
> version 5.0.18-nt
> ft_boolean_syntax + -><()~*:""&|
> ft_max_word_len 84
> ft_min_word_len 4
> ft_query_expansion_limit 20
> ft_stopword_file (built-in)
> 
> 
> Any advice?
> 
> Thanks
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx