--- suite/storage_engine/repair_table.result 2017-05-24 01:09:07.274213486 +0300 +++ suite/storage_engine/repair_table.reject 2017-05-24 01:10:25.466214949 +0300 @@ -4,56 +4,50 @@ CREATE TABLE t2 (a , b ) ENGINE= ; REPAIR TABLE t1; Table Op Msg_type Msg_text -test.t1 repair status OK +test.t1 repair note The storage engine for the table doesn't support repair INSERT INTO t1 (a,b) VALUES (3,'c'); INSERT INTO t2 (a,b) VALUES (4,'d'); REPAIR NO_WRITE_TO_BINLOG TABLE t1, t2; Table Op Msg_type Msg_text -test.t1 repair status OK -test.t2 repair status OK +test.t1 repair note The storage engine for the table doesn't support repair +test.t2 repair note The storage engine for the table doesn't support repair INSERT INTO t2 (a,b) VALUES (5,'e'),(6,'f'); REPAIR LOCAL TABLE t2; Table Op Msg_type Msg_text -test.t2 repair status OK +test.t2 repair note The storage engine for the table doesn't support repair INSERT INTO t1 (a,b) VALUES (7,'g'),(8,'h'); INSERT INTO t2 (a,b) VALUES (9,'i'); REPAIR LOCAL TABLE t2, t1 EXTENDED; Table Op Msg_type Msg_text -test.t2 repair status OK -test.t1 repair status OK +test.t2 repair note The storage engine for the table doesn't support repair +test.t1 repair note The storage engine for the table doesn't support repair INSERT INTO t1 (a,b) VALUES (10,'j'); INSERT INTO t2 (a,b) VALUES (11,'k'); REPAIR TABLE t1, t2 QUICK USE_FRM; Table Op Msg_type Msg_text -test.t1 repair warning Number of rows changed from 0 to 6 -test.t1 repair status OK -test.t2 repair warning Number of rows changed from 0 to 5 -test.t2 repair status OK +test.t1 repair note The storage engine for the table doesn't support repair +test.t2 repair note The storage engine for the table doesn't support repair INSERT INTO t1 (a,b) VALUES (12,'l'); INSERT INTO t2 (a,b) VALUES (13,'m'); REPAIR NO_WRITE_TO_BINLOG TABLE t1, t2 QUICK EXTENDED USE_FRM; Table Op Msg_type Msg_text -test.t1 repair warning Number of rows changed from 0 to 7 -test.t1 repair status OK -test.t2 repair warning Number of rows changed from 0 to 6 -test.t2 repair status OK +test.t1 repair note The storage engine for the table doesn't support repair +test.t2 repair note The storage engine for the table doesn't support repair FLUSH TABLE t1; INSERT INTO t1 (a,b) VALUES (14,'n'); -ERROR HY000: Incorrect file format 't1' +ERROR HY000: Table 't1' is read only # Statement ended with one of expected results (0,130,ER_FAILED_READ_FROM_PAR_FILE,ER_OPEN_AS_READONLY). # If you got a difference in error message, just add it to rdiff file CHECK TABLE t1; Table Op Msg_type Msg_text -test.t1 check Error Incorrect file format 't1' -test.t1 check error Corrupt +test.t1 check status OK SELECT a,b FROM t1; -ERROR HY000: Incorrect file format 't1' +a b # Statement ended with one of expected results (0,130,ER_FAILED_READ_FROM_PAR_FILE,ER_OPEN_AS_READONLY). # If you got a difference in error message, just add it to rdiff file REPAIR TABLE t1; Table Op Msg_type Msg_text -test.t1 repair Error Incorrect file format 't1' -test.t1 repair error Corrupt +test.t1 repair note The storage engine for the table doesn't support repair DROP TABLE t1, t2; call mtr.add_suppression("Got an error from thread_id=.*"); call mtr.add_suppression("MySQL thread id .*, query id .* localhost.*root Checking table"); @@ -63,46 +57,33 @@ CREATE TABLE t1 (a , b , (a)) ENGINE= ; REPAIR TABLE t1; Table Op Msg_type Msg_text -test.t1 repair status OK +test.t1 repair note The storage engine for the table doesn't support repair INSERT INTO t1 (a,b) VALUES (7,'g'),(8,'h'); REPAIR TABLE t1 EXTENDED; Table Op Msg_type Msg_text -test.t1 repair status OK +test.t1 repair note The storage engine for the table doesn't support repair INSERT INTO t1 (a,b) VALUES (10,'j'); REPAIR TABLE t1 USE_FRM; Table Op Msg_type Msg_text -test.t1 repair warning Number of rows changed from 0 to 3 -test.t1 repair status OK +test.t1 repair note The storage engine for the table doesn't support repair db.opt -t1.MYD -t1.MYI +t1.MRG t1.frm INSERT INTO t1 (a,b) VALUES (14,'n'),(15,'o'); # Statement ended with one of expected results (0,144). # If you got a difference in error message, just add it to rdiff file FLUSH TABLE t1; -Restoring /test/t1.MYD +Restoring /test/t1.MRG CHECK TABLE t1; Table Op Msg_type Msg_text -test.t1 check error Size of datafile is: 39 Should be: 65 -test.t1 check error Corrupt +test.t1 check status OK SELECT a,b FROM t1; -ERROR HY000: Index for table 't1' is corrupt; try to repair it -# Statement ended with one of expected results (0,ER_NOT_KEYFILE,144). -# If you got a difference in error message, just add it to rdiff file -INSERT INTO t1 (a,b) VALUES (14,'n'),(15,'o'); -ERROR HY000: Table './test/t1' is marked as crashed and last (automatic?) repair failed -# Statement ended with one of expected results (0,144). -# If you got a difference in error message, just add it to rdiff file -FLUSH TABLE t1; -Restoring /test/t1.MYI -CHECK TABLE t1; -Table Op Msg_type Msg_text -test.t1 check warning Table is marked as crashed and last repair failed -test.t1 check error Size of datafile is: 39 Should be: 65 -test.t1 check error Corrupt -SELECT a,b FROM t1; -ERROR HY000: Table './test/t1' is marked as crashed and last (automatic?) repair failed +a b +7 g +8 h +10 j +14 n +15 o # Statement ended with one of expected results (0,ER_NOT_KEYFILE,144). # If you got a difference in error message, just add it to rdiff file DROP TABLE t1;