Debian Codegraph @

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

raw
1 connect con1, localhost, root,,;
2 #
3 # Bug#36808088 Inplace ALTER TABLE might fail with duplicate key error
4 # if concurrent insertions
5 #
6 connection default;
7 CREATE TABLE t1 (pk CHAR(5) PRIMARY KEY);
8 INSERT INTO t1 VALUES ('aaaaa'), ('bbbbb'), ('ccccc'), ('ddddd'), ('eeeee');
9 connection con1;
10 SET DEBUG='+d,ddl_buf_add_two';
11 SET DEBUG_SYNC='ddl_bulk_inserter_latches_released SIGNAL latches_released WAIT_FOR go';
12 # Send ALTER TABLE INPLACE which rebuilds table.
13 ALTER TABLE t1 ENGINE=InnoDB, ALGORITHM=INPLACE;
14 connection default;
15 SET DEBUG_SYNC='now WAIT_FOR latches_released';
16 INSERT INTO t1 VALUES ('ccaaa');
17 SET DEBUG_SYNC='now SIGNAL go';
18 connection con1;
19 # Reap ALTER TABLE
20 # Before fix it failed with duplicate key error.
21 SELECT COUNT(*) FROM t1;
22 COUNT(*)
23 6
24 # Test Cleanup.
25 SET DEBUG_SYNC= 'RESET';
26 connection default;
27 SET DEBUG_SYNC= 'RESET';
28 DROP TABLE t1;
29 #
30 # Cleanup
31 disconnect con1;