MySQL Bugs: #81930: incorrect result with InnoDB FTS and subquery

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:	None
Category:	MySQL Server: FULLTEXT search	Severity:	S3 (Non-critical)
Version:	5.6, 5.7, 5.6.31	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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

# INNODB_FTS: INVESTIGATE
--echo # should return 0

Suggested fix:
do not commit incorrect test results into the main branch

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".

Thanks,
Umesh