Debian Codegraph @

mysql-test/suite/innodb/t/undo_leak.test

raw
1 --source include/have_innodb.inc
2 --source include/have_sequence.inc
3 --source include/have_debug.inc
4 --source include/not_embedded.inc
5
6 let $restart_parameters=--debug_dbug=d,undo_segment_leak;
7 --source include/restart_mysqld.inc
8 SET GLOBAL INNODB_FILE_PER_TABLE=0;
9 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL)ENGINE=InnoDB;
10 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
11 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
12 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
13 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
14 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
15 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
16 UPDATE t1 SET f1 = f1 + 1 WHERE f1 > 1000;
17 UPDATE t1 SET f2 = f2 + 1 WHERE f1 > 1000;
18 UPDATE t1 SET f1 = f2 + 1 WHERE f1 > 1000;
19 UPDATE t1 SET f2 = f1 + 1 WHERE f1 > 1000;
20 DELETE FROM t1;
21 DROP TABLE t1;
22 set GLOBAL innodb_fast_shutdown=0;
23 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
24 let $restart_parameters=;
25 --source include/restart_mysqld.inc
26 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;