Bug #81930 incorrect result with InnoDB FTS and subquery
Submitted: 20 Jun 2016 10:54 Modified: 20 Jun 2016 11:34
Reporter: Sergei Golubchik Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: FULLTEXT search Severity:S3 (Non-critical)
Version:5.6, 5.7, 5.6.31 OS:Any
Assigned to: CPU Architecture:Any

[20 Jun 2016 10:54] Sergei Golubchik
InnoDB FTS returns incorrect result in the following query:

SELECT count(*) FROM t1 WHERE 
  not exists(
   SELECT 1 FROM t2, t3
   WHERE t3.a=t1.a AND MATCH(b2) AGAINST('scargill' IN BOOLEAN MODE)

MyISAM FTS works correctly.

How to repeat:
see mysql-test/suite/innodb_fts/t/fulltest.test around lines

--echo # should return 0

Suggested fix:
do not commit incorrect test results into the main branch
[20 Jun 2016 11:34] Umesh Shastry
Hello Sergei,

Thank you for the report and feedback.
Observed this with 5.6.31 build.
I assume that you meant "suite/innodb_fts/t/fulltext.test".