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