Debian Codegraph @

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

raw
1 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2 #
3 # MDEV-23244 ALTER TABLE…ADD PRIMARY KEY fails to flag
4 # duplicate key error from concurrent DML
5 #
6 CREATE TABLE t0 (pk INT PRIMARY KEY) ENGINE=InnoDB;
7 CREATE TABLE t1 (c CHAR(2) NOT NULL) ENGINE=InnoDB;
8 INSERT INTO t1 VALUES('cd');
9 connect con1,localhost,root,,;
10 BEGIN;
11 INSERT INTO t0 VALUES(1);
12 connection default;
13 SET DEBUG_SYNC='row_log_table_apply1_before SIGNAL dml WAIT_FOR dml_done';
14 ALTER TABLE t1 ADD PRIMARY KEY(c(1));
15 connection con1;
16 SET DEBUG_SYNC='now WAIT_FOR dml';
17 INSERT INTO t1 VALUES ('ab'),('ac');
18 COMMIT;
19 SET DEBUG_SYNC='now SIGNAL dml_done';
20 disconnect con1;
21 connection default;
22 ERROR 23000: Duplicate entry 'a' for key 'PRIMARY'
23 SET DEBUG_SYNC='RESET';
24 SELECT * FROM t1;
25 c
26 cd
27 ab
28 ac
29 DROP TABLE t0,t1;
30 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;
31 #
32 # MDEV-35419 Server crashes when a adding column to the table which has a primary key using hash
33 #
34 create table t1 (a int,primary key using hash (a)) engine=innodb;
35 alter table t1 add b int;
36 drop table t1;
37 # End of 11.7 tests