Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/have_debug.inc
3 --source include/have_debug_sync.inc
4
5 # Encounter aborted online index during rollback of bulk insert
6
7 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL,
8 PRIMARY KEY(f1))ENGINE=InnoDB;
9 INSERT INTO t1 VALUES(1, 2), (2, 2);
10
11 SET DEBUG_SYNC="innodb_rollback_inplace_alter_table SIGNAL dml_start WAIT_FOR dml_commit";
12 send ALTER TABLE t1 ADD UNIQUE KEY(f2);
13
14 connect(con1,localhost,root,,,);
15 SET DEBUG_SYNC="now WAIT_FOR dml_start";
16 BEGIN;
17 DELETE FROM t1;
18 SET DEBUG_SYNC="now SIGNAL dml_commit";
19
20 connection default;
21 --error ER_DUP_ENTRY
22 reap;
23 connection con1;
24 COMMIT;
25 TRUNCATE TABLE t1;
26 SET unique_checks=0, foreign_key_checks=0;
27 BEGIN;
28 INSERT INTO t1 VALUES(1, 2);
29 ROLLBACK;
30
31 connection default;
32 SELECT * FROM t1;
33 SHOW CREATE TABLE t1;
34 disconnect con1;
35 DROP TABLE t1;
36 SET DEBUG_SYNC=RESET;