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:
None 
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

[3 Apr 2009 23:30] aaron lee
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);
[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".