Bug #44397 | Negative relevancy value for boolean fulltext query using a left join | ||
---|---|---|---|
Submitted: | 22 Apr 2009 2:46 | Modified: | 22 Apr 2009 12:29 |
Reporter: | Tim McLaughlin | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: FULLTEXT search | Severity: | S2 (Serious) |
Version: | 5.0.79, 5.1.33, 5.1.34, 6.0.9 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | fulltext, left join, NOT NULL, null |
[22 Apr 2009 2:46]
Tim McLaughlin
[22 Apr 2009 7:38]
Valeriy Kravchuk
Negative relevance is definitely a bug. Verified with 5.0.79, 5.1.34 and 6.0.9 also.
[22 Apr 2009 12:30]
Tim McLaughlin
I discovered a temporary workaround for this bug: SELECT men.name AS mans_name, men.link, women.name AS womans_name, MATCH(men.name, women.name) AGAINST('Simpson Syzlak Willie' IN BOOLEAN MODE) AS relevance FROM men LEFT JOIN (SELECT * FROM women) AS women ON men.link = women.id # This produces the result I would expect: # mans_name link womans_name relevance # Homer Simpson 10 Marge Simpson 1 # Moe Syzlak NULL NULL 1 # Groundskeeper Willie 0 NULL 1
[11 Feb 2010 16:44]
Pernot Christian
up the bug is still present on 5.0.90 and the workaround is slow...