Debian Codegraph @

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

raw
1 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL,
2 PRIMARY KEY(f1))ENGINE=InnoDB;
3 INSERT INTO t1 VALUES(1, 2), (2, 2);
4 SET DEBUG_SYNC="innodb_rollback_inplace_alter_table SIGNAL dml_start WAIT_FOR dml_commit";
5 ALTER TABLE t1 ADD UNIQUE KEY(f2);
6 connect con1,localhost,root,,,;
7 SET DEBUG_SYNC="now WAIT_FOR dml_start";
8 BEGIN;
9 DELETE FROM t1;
10 SET DEBUG_SYNC="now SIGNAL dml_commit";
11 connection default;
12 ERROR 23000: Duplicate entry '2' for key 'f2'
13 connection con1;
14 COMMIT;
15 TRUNCATE TABLE t1;
16 SET unique_checks=0, foreign_key_checks=0;
17 BEGIN;
18 INSERT INTO t1 VALUES(1, 2);
19 ROLLBACK;
20 connection default;
21 SELECT * FROM t1;
22 f1 f2
23 SHOW CREATE TABLE t1;
24 Table Create Table
25 t1 CREATE TABLE `t1` (
26 `f1` int(11) NOT NULL,
27 `f2` int(11) NOT NULL,
28 PRIMARY KEY (`f1`)
29 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
30 disconnect con1;
31 DROP TABLE t1;
32 SET DEBUG_SYNC=RESET;