| 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: | Windows (window7 64) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | full-text search | ||
[19 Oct 2015 7:37]
MySQL Verification Team
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. Thanks, Umesh
Description: Hello, 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 ft_min_word_len=1 ft_stopword_file='' 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