102
102
# End of 4.1 tests
105
--echo #Bug#12842206 INNODB LOCKING REGRESSION FOR INSERT IGNORE
106
--echo #fixed by re-fixing Bug#7975
107
--echo #aka Bug#11759688 52020: InnoDB can still deadlock on just INSERT...
111
CREATE TABLE t1 (a INT PRIMARY KEY, b INT NOT NULL) ENGINE=InnoDB;
113
INSERT INTO t1 VALUES(3,1);
116
# this used to wrongly acquire an X lock; now it takes an S lock
117
INSERT IGNORE INTO t1 VALUES(3,14);
121
# this used to wrongly acquire an X lock; now it takes an S lock
122
INSERT IGNORE INTO t1 VALUES(3,23);
124
SELECT * FROM t1 FOR UPDATE;
127
# Check that the above SELECT is blocked
129
select count(*) = 1 from information_schema.processlist
130
where state = 'Sending data' and
131
info = 'SELECT * FROM t1 FOR UPDATE';
132
--source include/wait_condition.inc