Bug #97 Bug with mysqlcheck -r --use-frm and HEAP table
Submitted: 25 Feb 2003 15:05 Modified: 27 Apr 2003 3:40
Reporter: jocelyn fournier (Silver Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.x OS:
Assigned to: Alexander Barkov CPU Architecture:Any

[25 Feb 2003 15:05] jocelyn fournier 
Description:
If mysqlcheck -r --use-frm is run against a HEAP table, 

"error    : Failed renaming .MYD file"

is displayed instead of

"error    : The handler for the table doesn't support check"

How to repeat:
Create a HEAP table and try to run mysqlcheck -r --use-frm on it.
[22 Apr 2003 8:19] Indrek Siitan 
mysqlcheck isn't the culprit as it just generates an SQL statement and 
executes is. the following produces same results:

mysql> REPAIR TABLE heaptest USE_FRM;
+----------+--------+----------+---------------------------
+
| Table    | Op     | Msg_type | Msg_text                  |
+----------+--------+----------+---------------------------
+
| heaptest | repair | error    | Failed renaming .MYD file |
+----------+--------+----------+---------------------------
+
1 row in set (0.00 sec)
[27 Apr 2003 3:40] Michael Widenius 
Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 
    http://www.mysql.com/doc/en/Installing_source_tree.html