Bug #892 myisamchk issues with tables without index and compressed tables

• Submitted: 22 Jul 2003 14:54
• Modified: 12 Aug 2003 7:01
• Reporter: Miguel Solorzano
• Status: Closed
• Category: MySQL Server: MyISAM storage engine
• Severity: S1 (Critical)
• Version: Ver 2.6
• OS: Windows (Windows)
• Assigned to: Sergei Golubchik
• CPU Architecture: Any

[22 Jul 2003 14:54] Miguel Solorzano

Description:
When issued the below command for all tables within a database...
 
myisamchk --recover --analyze --sort-index --sort-records=1 --verbose F:\mysql\data\test\*.MYI

First issue: for a table without an index. It displays the below error:

myisamchk: error: Can't sort table 'F:\mysql\data\test\billtype.MYI' on key 1;
No such key

and lets marked the table as crashed.

Second issue: the process stops once a compressed table is encountered.
I would prefer myisamchk to just continue with the next table.

How to repeat:
Create a database with tables without index and tables compressed.
Apply the command showed.

[30 Jul 2003 5:05] MySQL Verification Team

One more problem.

When :

myisamchk -r -a 

is invoked, then only first one is executed and second never.

[12 Aug 2003 7:01] Sergei Golubchik

"marked the table as crashed." - fixed in 4.0.15
other two issues - cannot repeat.