Debian Codegraph @

mysql-test/suite/innodb/r/innodb_force_recovery_rollback.result

raw
1 FLUSH TABLES;
2 #
3 # MDEV-21217 innodb_force_recovery=2 may wrongly abort the rollback
4 # of recovered transactions
5 #
6 connect con0,localhost,root;
7 CREATE TABLE t0 (a INT PRIMARY KEY) ENGINE=InnoDB;
8 BEGIN;
9 INSERT INTO t0 SELECT * FROM seq_1_to_1000;
10 connection default;
11 SET GLOBAL innodb_flush_log_at_trx_commit=1;
12 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
13 # restart: --innodb-force-recovery=2
14 disconnect con0;
15 connection default;
16 SELECT * FROM t0 LIMIT 0 LOCK IN SHARE MODE;
17 a
18 DROP TABLE t0,t1;