diff options
| author | Michael Widenius <monty@askmonty.org> | 2012-03-30 13:42:52 +0300 |
|---|---|---|
| committer | Michael Widenius <monty@askmonty.org> | 2012-03-30 13:42:52 +0300 |
| commit | 9b8542a4f6abde851ff428d0b6cffb789c5ccede (patch) | |
| tree | 0cfbd3e776cf369bc23b3923787f07d32c1e3aa7 /mysql-test/suite/maria/r | |
| parent | bbf1a7961a37daa08e9818d381df1bca9e562bed (diff) | |
| download | mariadb-git-9b8542a4f6abde851ff428d0b6cffb789c5ccede.tar.gz | |
Fixed bug lp:967914 "CHECK TABLE persistently reports table corruption after removing Aria logs"
Fixed that repair removes the 'table is moved' mark.
mysql-test/suite/maria/r/maria-autozerofill.result:
Test case for lp:967914
mysql-test/suite/maria/t/maria-autozerofill.test:
Test case for lp:967914
storage/maria/ha_maria.cc:
Fixed that repair removes the 'table is moved' mark.
Diffstat (limited to 'mysql-test/suite/maria/r')
| -rw-r--r-- | mysql-test/suite/maria/r/maria-autozerofill.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/suite/maria/r/maria-autozerofill.result b/mysql-test/suite/maria/r/maria-autozerofill.result index 7fa47814ee5..b719dbaebcb 100644 --- a/mysql-test/suite/maria/r/maria-autozerofill.result +++ b/mysql-test/suite/maria/r/maria-autozerofill.result @@ -10,6 +10,8 @@ create table t3 (a int) engine=maria; INSERT INTO t3 VALUES (1),(2); create table t4 (a int) engine=maria; INSERT INTO t4 VALUES (1),(2); +create table t5 (a int) engine=maria; +INSERT INTO t5 VALUES (1),(2); flush tables; create_rename_lsn has non-magic value * shut down mysqld, removed logs, restarted it @@ -35,6 +37,9 @@ mysqltest.t2 check error Corrupt repair table t2; Table Op Msg_type Msg_text mysqltest.t2 repair status OK +check table t2; +Table Op Msg_type Msg_text +mysqltest.t2 check status OK optimize table t3; Table Op Msg_type Msg_text mysqltest.t3 optimize Note Zerofilling moved table ./mysqltest/t3 @@ -43,4 +48,16 @@ analyze table t4; Table Op Msg_type Msg_text mysqltest.t4 analyze Note Zerofilling moved table ./mysqltest/t4 mysqltest.t4 analyze status OK +repair table t5; +Table Op Msg_type Msg_text +mysqltest.t5 repair status OK +check table t5; +Table Op Msg_type Msg_text +mysqltest.t5 check status OK +repair table t5; +Table Op Msg_type Msg_text +mysqltest.t5 repair status OK +check table t5; +Table Op Msg_type Msg_text +mysqltest.t5 check status OK drop database mysqltest; |