| Bug #5547 | Boolean search crash | ||
|---|---|---|---|
| Submitted: | 13 Sep 2004 17:05 | Modified: | 14 Sep 2004 8:33 |
| Reporter: | Chip Kellam | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | 4.0.21 | OS: | Linux (Redhat Linux) |
| Assigned to: | CPU Architecture: | Any | |
[14 Sep 2004 8:33]
Alexander Keremidarski
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to 'Open'. Thank you for your interest in MySQL. Additional info: Please provide the table structure as shown by SHOW CREATE TABLE statement mysql> SELECT * FROM t WHERE MATCH (song_title) AGAINST ('check out my huge 12" record' IN BOOLEAN MODE); +------------------------------+ | song_title | +------------------------------+ | check out my huge 12" record | +------------------------------+ 1 row in set (0.00 sec)
Description: I a user searches for 'Some Album 12"', the " will cause MySQL to crash. While MySQL should not crash on this instance, it is easy to see why the input is not valid: it is the start of a literal match that is never closed. Escaping the single " doesn't work either. How to repeat: MATCH (song_title) AGAINST ('check out my huge 12" record' IN BOOLEAN MODE)