Debian Codegraph @

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

raw
1 #
2 # Bug#19904003 INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG=1
3 # CAUSES INFINITE PAGE SPLIT
4 #
5 SET GLOBAL innodb_limit_optimistic_insert_debug=1;
6 CREATE TABLE t1(c1 INT PRIMARY KEY) ENGINE=InnoDB
7 PARTITION BY HASH (c1) PARTITIONS 15;
8 DROP TABLE t1;
9 SET GLOBAL innodb_limit_optimistic_insert_debug=0;
10 #
11 # Bug#25082593 FOREIGN KEY VALIDATION DOESN'T NEED
12 # TO ACQUIRE GAP LOCK IN READ COMMITTED
13 #
14 SET GLOBAL innodb_limit_optimistic_insert_debug=2;
15 CREATE TABLE t1(col1 INT PRIMARY KEY) ENGINE=INNODB;
16 CREATE TABLE t2(col1 INT PRIMARY KEY, col2 INT NOT NULL,
17 FOREIGN KEY(col2) REFERENCES t1(col1)) ENGINE=INNODB;
18 INSERT INTO t1 VALUES(1), (3), (4);
19 connect con1,localhost,root;
20 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
21 START TRANSACTION;
22 INSERT INTO t2 VALUES(1, 3);
23 connection default;
24 START TRANSACTION;
25 INSERT INTO t1 VALUES(2);
26 disconnect con1;
27 SET GLOBAL innodb_limit_optimistic_insert_debug=0;
28 DROP TABLE t2;
29 DROP TABLE t1;