Debian Codegraph @

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

raw
1 CREATE TABLE t1(f1 char(200), f2 char(200), f3 char(200),
2 f4 char(200), f5 char(200), f6 char(200),
3 f7 char(200), f8 char(200))ENGINE=InnoDB;
4 INSERT INTO t1 SELECT '','','','','','','','' FROM seq_1_to_16384;
5 SET DEBUG_SYNC = 'inplace_after_index_build SIGNAL rebuilt WAIT_FOR dml_pause';
6 SET DEBUG_SYNC = 'alter_table_inplace_before_lock_upgrade SIGNAL dml_restart WAIT_FOR dml_done';
7 SET DEBUG_SYNC = 'row_log_table_apply2_before SIGNAL ddl_start';
8 ALTER TABLE t1 FORCE, ALGORITHM=INPLACE;
9 connect con1,localhost,root,,test;
10 SET DEBUG_SYNC = 'now WAIT_FOR rebuilt';
11 BEGIN;
12 INSERT INTO t1 SELECT '','','','','','','','' FROM seq_1_to_16384;
13 SET DEBUG_SYNC = 'now SIGNAL dml_pause';
14 SET DEBUG_SYNC = 'now WAIT_FOR dml_restart';
15 ROLLBACK;
16 BEGIN;
17 INSERT INTO t1 SELECT '','','','','','','','' FROM seq_1_to_81920;
18 ROLLBACK;
19 BEGIN;
20 INSERT INTO t1 SELECT '','','','','','','','' FROM seq_1_to_114688;
21 ROLLBACK;
22 SET DEBUG_SYNC = 'now SIGNAL dml_done';
23 connect con2, localhost,root,,test;
24 SET DEBUG_SYNC = 'now WAIT_FOR ddl_start';
25 CREATE TABLE t2(f1 INT NOT NULL)ENGINE=InnoDB;
26 connection default;
27 SHOW CREATE TABLE t1;
28 Table Create Table
29 t1 CREATE TABLE `t1` (
30 `f1` char(200) DEFAULT NULL,
31 `f2` char(200) DEFAULT NULL,
32 `f3` char(200) DEFAULT NULL,
33 `f4` char(200) DEFAULT NULL,
34 `f5` char(200) DEFAULT NULL,
35 `f6` char(200) DEFAULT NULL,
36 `f7` char(200) DEFAULT NULL,
37 `f8` char(200) DEFAULT NULL
38 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
39 SELECT COUNT(*) FROM t1;
40 COUNT(*)
41 16384
42 SET DEBUG_SYNC = 'RESET';
43 DROP TABLE t1, t2;