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