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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.