Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
I created a simple table in MariaDB and then when I tried to access it in MySQL, the table is reported as damaged and can't be repaired.
Versions used were 5.1.42 of each on Linux x86.
Script:
In MariaDB:
use test;
CREATE TABLE t1 (a char(100), b int) ENGINE=myisam;
INSERT INTO t1 values ('aaaa', 10);
SELECT * FROM t1;
Shutdown MariaDB and point MySQL at the same datadir.
In MySQL:
use test;
SELECT * FROM t1;
REPAIR TABLE t1;
Errors from MySQL:
mysql> select * from t1;
ERROR 1035 (HY000): Old key file for table 't1'; repair it!
mysql> repair table t1;
--------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
--------------------------------------------------------------+
| test.t1 | repair | Error | Old key file for table 't1'; repair it! |
| test.t1 | repair | error | Corrupt |
--------------------------------------------------------------+
2 rows in set (0.00 sec)