| Bug #44085 | full-text boolean search with + and wild card and short word returns empty list | ||
|---|---|---|---|
| Submitted: | 3 Apr 2009 23:30 | Modified: | 4 May 2009 2:24 |
| Reporter: | aaron lee | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server: FULLTEXT search | Severity: | S2 (Serious) |
| Version: | 5.0.51a | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | boolean, empty list, full-text, search, wild card | ||
[4 Apr 2009 2:24]
MySQL Verification Team
Thank you for the bug report. Could you please test against the latest released version and if still you get the same result please provide a test case with create table, dump file for insert, queries with actual and expected results. Thanks in advance.
[4 May 2009 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: Searching in full-text boolean mode using +, *, and short word returns nothing. My database has an address field "600 queen st" below is a description on what happens when doing a search. This query returns nothing: SELECT * FROM `homes` WHERE match address against ('+600* +queen*' in boolean mode); This query returns "600 queen st": SELECT * FROM `homes` WHERE match address against ('+600 +queen*' in boolean mode); This query returns "600 queen st": SELECT * FROM `homes` WHERE match address against ('600* +queen*' in boolean mode); This query returns "600 queen st": SELECT * FROM `homes` WHERE match address against ('600 +queen*' in boolean mode); Why does including + and * on a short word finds nothing? How to repeat: Do a search in full-text boolean mode with +, * and a short word. Example statement: SELECT * FROM `homes` WHERE match address against ('+600* +queen*' in boolean mode);