diff options
Diffstat (limited to 'mysql-test/suite/maria/maria-autozerofill.result')
| -rw-r--r-- | mysql-test/suite/maria/maria-autozerofill.result | 83 |
1 files changed, 83 insertions, 0 deletions
diff --git a/mysql-test/suite/maria/maria-autozerofill.result b/mysql-test/suite/maria/maria-autozerofill.result new file mode 100644 index 00000000..e135d3d7 --- /dev/null +++ b/mysql-test/suite/maria/maria-autozerofill.result @@ -0,0 +1,83 @@ +call mtr.add_suppression("Table 't1' is marked as crashed and should be repaired"); +drop database if exists mysqltest; +create database mysqltest; +connect admin, localhost, root,,mysqltest,,; +connection default; +use mysqltest; +create table t1(a int) engine=aria; +insert into t1 values(1); +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); +create table t5 (a int) engine=aria; +INSERT INTO t5 VALUES (1),(2); +create table t6 (a int) engine=aria; +INSERT INTO t6 VALUES (1),(2); +flush tables; +create_rename_lsn has non-magic value +connection default; +connection admin; +* shut down mysqld, removed logs, restarted it +connection default; +select * from t1; +a +1 +Warnings: +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 +# +# BUG#44422 "mysql_upgrade destroys Maria tables?" +# Check repair and optimize of moved table +# +check table t2; +Table Op Msg_type Msg_text +mysqltest.t2 check error Table is probably from another system and must be zerofilled or repaired ('REPAIR TABLE table_name') 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 probably from another system and must be zerofilled or repaired ('REPAIR TABLE table_name') to be usable on this system +mysqltest.t2 check error Corrupt +repair table t2; +Table Op Msg_type Msg_text +mysqltest.t2 repair info Running zerofill on moved table +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 +mysqltest.t3 optimize status OK +analyze table t4; +Table Op Msg_type Msg_text +mysqltest.t4 analyze status Engine-independent statistics collected +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 info Running zerofill on moved table +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 +select * from t6; +a +1 +2 +check table t6; +Table Op Msg_type Msg_text +mysqltest.t6 check status OK +drop database mysqltest; |