MySQL Forums
Forum List  »  Full-Text Search

Full Text Query Problem in 5.1
Posted by: Irfan Ali
Date: July 29, 2009 05:54AM

Hi,

I upraded my database server from 4.1 to 5.1.32. But somehow following query doesn't shows any results in 5.1 it just running look likes query hung.

mysql 5.1.32> SELECT colname FROM table1
WHERE (related=1 or related=2) AND match(colname) against ('+dimension w*h*d' in boolean mode)
AND (LENGTH(TRIM(colname)) - LENGTH(REPLACE(TRIM(colname), ' ', '')))<4
GROUP BY colname ORDER BY date DESC LIMIT 0,50;


"*" between w h d ('+dimension w*h*d' in boolean mode) causing the problem. when i remove those * query runs without any problem. I tried same query on MySQL 4.1 it runs without any problem. Might be i need to edit characterset file but not sure.

mysql> show variables like '%ft%';

+--------------------------+----------------+
| Variable_name | Value |
+--------------------------+----------------+
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 3 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
+--------------------------+----------------+

full text related parameters are same on both i.e. MySQL 4.1 & MySQL 5.1.

Thanks,

Options: ReplyQuote


Subject
Views
Written By
Posted
Full Text Query Problem in 5.1
4036
July 29, 2009 05:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.