Debian Codegraph @

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

raw
1 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL,
2 f3 CHAR(200), f4 CHAR(200),
3 PRIMARY KEY(f1))ENGINE=InnoDB;
4 INSERT INTO t1 VALUES(6000, 6000, "InnoDB", "MariaDB");
5 SET DEBUG_SYNC="inplace_after_index_build SIGNAL dml_start WAIT_FOR dml_commit";
6 ALTER TABLE t1 ADD UNIQUE KEY(f2), ADD UNIQUE INDEX(f4(10));
7 connect con1,localhost,root,,,;
8 SET DEBUG_SYNC="now WAIT_FOR dml_start";
9 BEGIN;
10 DELETE FROM t1 WHERE f1= 6000;
11 INSERT INTO t1 VALUES(6000, 6000, "InnoDB", "MariaDB");
12 ROLLBACK;
13 BEGIN;
14 DELETE FROM t1 WHERE f1= 6000;
15 INSERT INTO t1 VALUES(6000, 6000, "InnoDB", "MariaDB");
16 INSERT INTO t1 SELECT seq, seq, repeat('a', 200), repeat('b', 200) FROM seq_1_to_4000;
17 COMMIT;
18 SET DEBUG_SYNC="now SIGNAL dml_commit";
19 connection default;
20 ERROR 23000: Duplicate entry '' for key '*UNKNOWN*'
21 SET DEBUG_SYNC="inplace_after_index_build SIGNAL dml_start WAIT_FOR dml_commit";
22 ALTER TABLE t1 ADD UNIQUE KEY(f2), ADD INDEX(f3(10));
23 connection con1;
24 SET DEBUG_SYNC="now WAIT_FOR dml_start";
25 BEGIN;
26 DELETE FROM t1;
27 INSERT INTO t1 SELECT seq, seq, repeat('d', 200), repeat('e', 200) FROM
28 seq_1_to_4000;
29 UPDATE t1 SET f3=repeat('c', 200), f4= repeat('d', 200), f2=3;
30 COMMIT;
31 SET DEBUG_SYNC="now SIGNAL dml_commit";
32 connection default;
33 ERROR 23000: Duplicate entry '' for key '*UNKNOWN*'
34 disconnect con1;
35 CHECK TABLE t1;
36 Table Op Msg_type Msg_text
37 test.t1 check status OK
38 DROP TABLE t1;
39 SET DEBUG_SYNC=reset;