129
129
# End of 4.1 tests
132
--echo #Bug#12842206 INNODB LOCKING REGRESSION FOR INSERT IGNORE
133
--echo #fixed by re-fixing Bug#7975
134
--echo #aka Bug#11759688 52020: InnoDB can still deadlock on just INSERT...
138
CREATE TABLE t1 (a INT PRIMARY KEY, b INT NOT NULL) ENGINE=InnoDB;
140
INSERT INTO t1 VALUES(3,1);
143
# this used to wrongly acquire an X lock; now it takes an S lock
144
INSERT IGNORE INTO t1 VALUES(3,14);
148
# this used to wrongly acquire an X lock; now it takes an S lock
149
INSERT IGNORE INTO t1 VALUES(3,23);
151
SELECT * FROM t1 FOR UPDATE;
154
# Check that the above SELECT is blocked
156
select count(*) = 1 from information_schema.processlist
157
where state = 'Sending data' and
158
info = 'SELECT * FROM t1 FOR UPDATE';
159
--source include/wait_condition.inc