Bug #89654 Match Against query fails with any capital letters
Submitted: 13 Feb 2018 16:40 Modified: 13 Mar 2018 17:52
Reporter: Alberto Lombardo Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: FULLTEXT search Severity:S2 (Serious)
Version:5.7.21 OS:CentOS
Assigned to: CPU Architecture:Any

[13 Feb 2018 16:40] Alberto Lombardo
Description:
Any search that includes any capital characters in the keyword(s) of a full text search (match against..in boolean and natural language mode), fails to find any matches.  Running the exact same query in 5.7.20 and 5.7.19 return a result set, 5.7.21 always returns an empty set.  
Limited testing shows that executing the same query in 5.7.21 with all lower case characters does return a result set, although not sure if it is the same result set as pre-5.7.21 release.

How to repeat:
run match against query in either boolean or natural language mode on MySQL server running on Centos 7.X

Suggested fix:
downgrade to 5.7.20 until a fix is provided.
[13 Feb 2018 17:52] MySQL Verification Team
Please provide the SQL script test case (create table, insert data, queries, real result). Attach it using Files tab. Thanks.
[14 Mar 2018 1: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".