Bug #34172 | The string '2007' can not be found in fulltext search | ||
---|---|---|---|
Submitted: | 30 Jan 2008 18:31 | Modified: | 31 Jan 2008 11:13 |
Reporter: | Jean-Pierre Praz | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: FULLTEXT search | Severity: | S3 (Non-critical) |
Version: | 5.1.22-rc | OS: | Linux (Fedora 6) |
Assigned to: | CPU Architecture: | Any |
[30 Jan 2008 18:31]
Jean-Pierre Praz
[30 Jan 2008 18:56]
Paul DuBois
How many rows are in the table, and in how many of them does 2007 occur? If it's half or more, 2007 will be considered "common" and ignored.
[31 Jan 2008 9:05]
Jean-Pierre Praz
The rows which match '2007' are more than half of the rows. So, what I discribed is not a bug but a feature :-) By the way, can this feature be configured to behave different?
[31 Jan 2008 11:13]
Valeriy Kravchuk
This is not a bug. Please, read http://dev.mysql.com/doc/refman/5.1/en/fulltext-natural-language.html. Use boolean search mode as a workaround, see http://dev.mysql.com/doc/refman/5.1/en/fulltext-boolean.html for the details.