1
##########################################################################
2
# LP bug #1035225 / MySQL bug #66301: INSERT ... ON DUPLICATE KEY UPDATE +
3
# innodb_autoinc_lock_mode=1 is broken
4
##########################################################################
6
--source include/have_innodb.inc
7
--source include/have_debug_sync.inc
10
drop table if exists t1;
14
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
17
UNIQUE KEY(k)) ENGINE=InnoDB;
21
--connect(con1, localhost, root)
22
--connect(con2, localhost, root)
29
SET DEBUG_SYNC='ha_write_row_end SIGNAL continue2 WAIT_FOR continue1';
30
--send INSERT INTO t1(k) VALUES (1), (2), (3) ON DUPLICATE KEY UPDATE c='1'
36
SET DEBUG_SYNC='ha_write_row_start WAIT_FOR continue2';
37
SET DEBUG_SYNC='after_mysql_insert SIGNAL continue1';
38
INSERT INTO t1(k) VALUES (2), (4), (5) ON DUPLICATE KEY UPDATE c='2';
43
SET DEBUG_SYNC='RESET';
44
SELECT * FROM t1 ORDER BY k;