summaryrefslogtreecommitdiff
path: root/mysql-test/suite/maria/r
diff options
context:
space:
mode:
authorMichael Widenius <monty@askmonty.org>2012-03-28 13:49:07 +0300
committerMichael Widenius <monty@askmonty.org>2012-03-28 13:49:07 +0300
commit3bc932ec175ae9ac2fc6c0c5be29002819c9b102 (patch)
tree142e8c1fdf2e1cd20740c27716b4fb692895db41 /mysql-test/suite/maria/r
parentc88e2679c60f56719b6d347c30374e69ffd3d5c4 (diff)
parent74b064933267f58b9201c46eb67454237d7664d3 (diff)
downloadmariadb-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.result29
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;