Debian Codegraph @

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

raw
1 --source include/big_test.inc
2 # debug sync points times out when using valgrind
3 --source include/not_valgrind.inc
4 --source include/have_innodb.inc
5 --source include/have_debug.inc
6 --source include/have_debug_sync.inc
7 --source include/have_sequence.inc
8 # This test often times out with MemorySanitizer.
9 --source include/not_msan.inc
10
11 CREATE TABLE t1(f1 char(200), f2 char(200), f3 char(200),
12 f4 char(200), f5 char(200), f6 char(200),
13 f7 char(200), f8 char(200))ENGINE=InnoDB;
14
15 INSERT INTO t1 SELECT '','','','','','','','' FROM seq_1_to_16384;
16
17 SET DEBUG_SYNC = 'inplace_after_index_build SIGNAL rebuilt WAIT_FOR dml_pause';
18 SET DEBUG_SYNC = 'alter_table_inplace_before_lock_upgrade SIGNAL dml_restart WAIT_FOR dml_done';
19 SET DEBUG_SYNC = 'row_log_table_apply2_before SIGNAL ddl_start';
20 --send
21 ALTER TABLE t1 FORCE, ALGORITHM=INPLACE;
22
23 --connect(con1,localhost,root,,test)
24 SET DEBUG_SYNC = 'now WAIT_FOR rebuilt';
25 BEGIN;
26 INSERT INTO t1 SELECT '','','','','','','','' FROM seq_1_to_16384;
27 SET DEBUG_SYNC = 'now SIGNAL dml_pause';
28 SET DEBUG_SYNC = 'now WAIT_FOR dml_restart';
29 ROLLBACK;
30
31 BEGIN;
32 INSERT INTO t1 SELECT '','','','','','','','' FROM seq_1_to_81920;
33 ROLLBACK;
34
35 BEGIN;
36 INSERT INTO t1 SELECT '','','','','','','','' FROM seq_1_to_114688;
37 ROLLBACK;
38
39 SET DEBUG_SYNC = 'now SIGNAL dml_done';
40
41 --connect(con2, localhost,root,,test)
42 SET DEBUG_SYNC = 'now WAIT_FOR ddl_start';
43 CREATE TABLE t2(f1 INT NOT NULL)ENGINE=InnoDB;
44
45 connection default;
46 reap;
47 SHOW CREATE TABLE t1;
48
49 SELECT COUNT(*) FROM t1;
50 SET DEBUG_SYNC = 'RESET';
51 DROP TABLE t1, t2;