Bug #4490 MySQL reproduceably crashes during fulltext search
Submitted: 9 Jul 2004 19:23 Modified: 9 Jul 2004 19:54
Reporter: Steffen Weber Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:4.0.20 OS:Linux (Gentoo Linux)
Assigned to: CPU Architecture:Any

[9 Jul 2004 19:23] Steffen Weber
Description:
The following query reproduceably crashes MySQL 4.0.20 on my server (Linux 2.4) as well as on my development system (Linux 2.6):

SELECT foo FROM bar WHERE MATCH (fulltextcolumn) AGAINST ('"search string' IN BOOLEAN MODE);

Notice that the search string from the user is: "search string
The closing " is omitted (user mistake), but MySQL should not crash because of this.

The reported error message is: "ERROR 2013: Lost connection to MySQL server during query"

The follwoing query (not using boolean mode) works fine:
SELECT foo FROM bar WHERE MATCH (fulltextcolumn) AGAINST ('"search string');

How to repeat:
Send the mentioned query to MySQL.
[9 Jul 2004 19:54] Sergei Golubchik
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

This bug was reported already:

http://bugs.mysql.com/3870
http://bugs.mysql.com/4197
http://bugs.mysql.com/4436

and it's already fixed in the development tree.