diff options
author | Michael Widenius <monty@askmonty.org> | 2012-03-28 13:49:07 +0300 |
---|---|---|
committer | Michael Widenius <monty@askmonty.org> | 2012-03-28 13:49:07 +0300 |
commit | 3bc932ec175ae9ac2fc6c0c5be29002819c9b102 (patch) | |
tree | 142e8c1fdf2e1cd20740c27716b4fb692895db41 /mysql-test/suite/maria/r | |
parent | c88e2679c60f56719b6d347c30374e69ffd3d5c4 (diff) | |
parent | 74b064933267f58b9201c46eb67454237d7664d3 (diff) | |
download | mariadb-git-3bc932ec175ae9ac2fc6c0c5be29002819c9b102.tar.gz |
Merge with 5.1
Diffstat (limited to 'mysql-test/suite/maria/r')
-rw-r--r-- | mysql-test/suite/maria/r/maria-autozerofill.result | 29 |
1 files changed, 27 insertions, 2 deletions
diff --git a/mysql-test/suite/maria/r/maria-autozerofill.result b/mysql-test/suite/maria/r/maria-autozerofill.result index 81df4cbab90..dc3d47bc6cc 100644 --- a/mysql-test/suite/maria/r/maria-autozerofill.result +++ b/mysql-test/suite/maria/r/maria-autozerofill.result @@ -4,17 +4,42 @@ create database mysqltest; use mysqltest; create table t1(a int) engine=aria; insert into t1 values(1); -flush table t1; +create table t2 (a int) engine=aria; +INSERT INTO t2 VALUES (1),(2); +create table t3 (a int) engine=aria; +INSERT INTO t3 VALUES (1),(2); +create table t4 (a int) engine=aria; +INSERT INTO t4 VALUES (1),(2); +flush tables; create_rename_lsn has non-magic value * shut down mysqld, removed logs, restarted it select * from t1; a 1 Warnings: -Error 1194 t1' is marked as crashed and should be repaired +Note 1194 Zerofilling moved table ./mysqltest/t1 flush table t1; Status: changed,sorted index pages,zerofilled insert into t1 values(2); flush table t1; create_rename_lsn has non-magic value +check table t2; +Table Op Msg_type Msg_text +mysqltest.t2 check error Table is from another system and must be zerofilled or repaired to be usable on this system +mysqltest.t2 check error Corrupt +check table t2; +Table Op Msg_type Msg_text +mysqltest.t2 check error Table is from another system and must be zerofilled or repaired to be usable on this system +mysqltest.t2 check error Corrupt +repair table t2; +Table Op Msg_type Msg_text +mysqltest.t2 repair status OK +optimize table t3; +Table Op Msg_type Msg_text +mysqltest.t3 optimize Note Zerofilling moved table ./mysqltest/t3 +mysqltest.t3 optimize status OK +analyze table t4; +Table Op Msg_type Msg_text +mysqltest.t4 analyze Note Zerofilling moved table ./mysqltest/t4 +mysqltest.t4 analyze status OK drop database mysqltest; |