Bug #942 The fulltext search finds false positives.
Submitted: 29 Jul 2003 3:04 Modified: 31 Jul 2003 8:50
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.0-alpha OS:Windows (Windows XP)
Assigned to: Sergei Golubchik CPU Architecture:Any

[29 Jul 2003 3:04] [ name withheld ]
Description:
The fulltext search finds false positives in some cases.

How to repeat:
mysql> SELECT * FROM test1 JOIN test2 USING(`test1_id`) WHERE MATCH (test1.name,
 test2.name) AGAINST('xxfoo' IN BOOLEAN MODE);
+----------+-------+----------+----------+-------+
| test1_id | name  | test2_id | test1_id | name  |
+----------+-------+----------+----------+-------+
|        1 | data1 |        1 |        1 | xxfoo |
|        1 | data1 |        2 |        1 | xxbar |
|        1 | data1 |        3 |        1 | xxbuz |
+----------+-------+----------+----------+-------+
3 rows in set (0.00 sec)

Expected was only the first line, not all three.

(I'll attach the table dump as a file)
[29 Jul 2003 3:05] [ name withheld ]
database scheme

Attachment: tabledump.sql (application/octet-stream, text), 798 bytes.

[31 Jul 2003 8:50] Sergei Golubchik
fixed in 4.0.15