Bug #78692 Full-Text Search cannot fuzzy search
Submitted: 4 Oct 2015 13:20 Modified: 19 Oct 2015 7:37
Reporter: pite peter Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server: FULLTEXT search Severity:S1 (Critical)
Version:5.6.17 OS:Microsoft Windows (window7 64)
Assigned to: CPU Architecture:Any
Tags: full-text search

[4 Oct 2015 13:20] pite peter

I have a table that the DB Engine is MyISAM.

One of the columns is a Full-Text Index.
when I do a match(X) against ('Y')... 
I only get  results that where  X='Y' ,but I want to get results that where X like "%Y%".
It looks that fuzzy search is not work.

and I have already make good config.
like this


others  not change

ps: I asked to many people but they don't konw why.

How to repeat:
repair tabel tablesname 

and I rebuild Full-Text  index  many times
[19 Oct 2015 7:37] Umesh Shastry
Hello pite peter,

Thank you for the report.
But version 5.6.17 is very old and many bugs were fixed since. Please upgrade to current version 5.6.27(http://dev.mysql.com/downloads/mysql/), try with it and inform us if problem still exists then please provide exact repeatable test case(show create table, subset of data to reproduce the issue). 

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.