No results when searching for numbers with decimal

[Jeremy Martin]

Hi,

I have recently just about finished some 100% custom forums for several user groups I own (www.logic-users.org)... I set up a binary full text search, to search our existing 250,000 messages (imported into my new forums from our YahooGroups archives).

I have set ft_min_word_len = 3 in my my.cnf and rebuild the indexes. I can search for 3 letter words like "abc" just fine but if I search for a 3 letter version number such as "7.1" I get zero results. I have tried searching for 7.1, "7.1" or '7.1' and even 7\.1 but there are never any results. I have not defined a custom stopword file but I'm wondering if "." is in the default stopwords maybe? It's not a binary operator but I can't figure out why my searches for 7.1 are not giving any results. That number is definitely not found in above 50% of the messages.

Example query searching for just 7.1 in any post since 1999:

SELECT forum_msg_id,match(message,subject) against ('7.1' in boolean mode) as score FROM messages WHERE forum_id = 1 AND match(message,subject) against ('7.1' in boolean mode) AND DATE(posted) >= DATE(FROM_UNIXTIME(937198800)) AND DATE(posted) <= DATE(FROM_UNIXTIME(1126587600)) ORDER BY score DESC, posted DESC LIMIT 25

The software these forums are for often uses 3 digit version numbers like 7.0, 7.1, etc and I'm sure we'll get a lot of searches including those version numbers so I'd like to get this working if possible.

Many thanks!
Jeremy