使用单引号搜索MySql FullText索引

Question

I am trying to search for a string with single quote against a FullText index:

select * 
from gems 
where MATCH (gems.title, gems.descr) AGAINST ('"winter\'s discontent"' IN BOOLEAN MODE)

The answer in this post suggests that it should work, but it does not. When I changed that example from MyIsam to InnoDB, it no longer worked. Even in MyIsam, the query above would return a match on 'winter'

Any ideas?

I am using mySql 5.6.11 InnoDB

A sqlFiddle can be found here and it also does not work. It contains the following:

CREATE TABLE gems 
    (
     id int auto_increment primary key, 
     title varchar(20), 
     descr varchar(100),
     FULLTEXT KEY `ft_title_descr` (`title`,`descr`)      
    );


INSERT INTO gems
(title, descr)
VALUES
('Post 1', 'Once upon a time'),
('Post 2', 'My winter\'s discontent');

Answer 1

Did some more Googling - seems this was a reported MySQL bug. I upgraded my mySQL version to 5.6.20 and this solved the problem.