Bug #1782 fulltext in boolean mode fails with left join

• Submitted: 7 Nov 2003 16:08
• Modified: 12 Nov 2003 9:34
• Reporter: [ name withheld ]
• Status: Can't repeat
• Category: MySQL Server: MyISAM storage engine
• Severity: S1 (Critical)
• Version: mysql-standard-4.0.13
• OS: sun-solaris2.8-sparc-64bit
• CPU Architecture: Any

[7 Nov 2003 16:08] [ name withheld ]

Description:
when you've a left join and you do fulltext search in boolean mode on right table it returns all rows which are in left tables with no corresponding rows in right tables. while if the search is withour boolean mode it doesn't return these rows.

How to repeat:
when you've a left join and you do fulltext search in boolean mode on right table it returns all rows which are in left tables with no corresponding rows in right tables. while if the search is withour boolean mode it doesn't return these rows.

[12 Nov 2003 9:34] Sergei Golubchik

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

already fixed in 4.0.14.
from changelog

   * Fixed incorrect results from `MATCH ... AGAINST' used with a `LEFT
     JOIN' query.

if it's not your bug, please provide a repeatable test case for the 4.0.16 and reopen the bugreport