Bug #20239 Strings with decimals don't work in FULLTEXT mode
Submitted: 3 Jun 2006 0:05 Modified: 6 Jun 2006 9:08
Reporter: E Brake Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4/5/5.1 OS:Linux (Linux(all))
Assigned to: CPU Architecture:Any

[3 Jun 2006 0:05] E Brake
Description:
When searching for a string with a decimal.
i.e. "Product 7.0.1" - any decimals in a string do not return results unless converted into spaces (where-in relevancy is lost)

How to repeat:
Create a fulltext table, make 'min_word' 1, add an entry with decimals, and try to return in FULLTEXT mode.

Suggested fix:
Fix it ?
[6 Jun 2006 9:08] Sveta Smirnova
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

As you can read at http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html the behavior is expected:  "The FULLTEXT parser determines where words start and end by looking for certain delimiter characters; for example, " " space), "," (comma), and "." (period).".

In MySQL 5.1 you also can use full text parser plugin interface: http://dev.mysql.com/doc/refman/5.1/en/plugin-full-text-plugins.html