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	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: MyISAM storage engine	Severity:	S1 (Critical)
Version:	Ver 2.6	OS:	Windows (Windows)
Assigned to:	Sergei Golubchik	CPU Architecture:	Any

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.

One more problem.

When :

myisamchk -r -a 

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

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

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.