Bug #84036 Incorrect result for MyISAM boolean mode fulltext query with negated phrase
Submitted: 2 Dec 2016 6:34 Modified: 2 Dec 2016 6:56
Reporter: Mark Derthick Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: FULLTEXT search Severity:S3 (Non-critical)
Version:5.7.13, 5.7.16 OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[2 Dec 2016 6:34] Mark Derthick
The SELECT query below returns no rows.  I expect it to return one row.

How to repeat:
CREATE TABLE foo (txt TEXT, FULLTEXT KEY txt (txt));

INSERT INTO foo VALUES('house white');

SELECT 1 FROM foo WHERE MATCH (txt) AGAINST ('+white +house -"white house"' IN BOOLEAN MODE);
[2 Dec 2016 6:56] Umesh Shastry
Hello Mark Derthick,

Thank you for the report and test case.