Bug #36495 Worklog search misses results
Submitted: 4 May 2008 20:51 Modified: 10 Jun 2008 17:49
Reporter: John David Duncan Email Updates:
Status: Closed Impact on me:
Category:MySQL Websites: MySQLForge Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[4 May 2008 20:51] John David Duncan
At forge.mysql.com/worklog, I try to search for "XML" in "Title and Description".  I get no results.  However, if I browse worklog tasks , I see item wl#1397, "XML -> SQL".   This should have matched my search.

How to repeat:
Search worklog for "XML" in "Title and Description"
[5 May 2008 18:42] Valeriy Kravchuk
Thank you for a problem report.
[10 Jun 2008 17:12] Jay Pipes
This is due to the server having ft_min_word_len = 4, so the fulltext indexes aren't matching stuff 3 characters or less...

I will work on a workaround for smaller words.
[10 Jun 2008 17:49] Jay Pipes
Fixed in r527.  The fix adds a check for words less than 3 characters long and implements a slower LIKE clause if found.  Not the best, but it works.