Full Text Query Problem in 5.1

[Irfan Ali]

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,