Debian Codegraph @

mysql-test/suite/encryption/r/corrupted_during_recovery.result

raw
1 CREATE TABLE t1(a BIGINT PRIMARY KEY) ENGINE=InnoDB, ENCRYPTED=YES;
2 INSERT INTO t1 VALUES(1);
3 CREATE TABLE t2(a BIGINT PRIMARY KEY) ENGINE=InnoDB, ENCRYPTED=YES;
4 INSERT INTO t1 VALUES(2);
5 SET GLOBAL innodb_flush_log_at_trx_commit=1;
6 INSERT INTO t2 VALUES(2);
7 # Kill the server
8 # Corrupt the pages
9 SELECT * FROM t1;
10 ERROR 42000: Unknown storage engine 'InnoDB'
11 SELECT * FROM t1;
12 ERROR HY000: Table `test`.`t1` is corrupted. Please drop the table and recreate.
13 SELECT * FROM t2;
14 a
15 2
16 CHECK TABLE t2;
17 Table Op Msg_type Msg_text
18 test.t2 check status OK
19 DROP TABLE t1, t2;