Debian Codegraph @

mysql-test/suite/innodb/t/insert_debug.test

raw
1 --source include/have_innodb.inc
2 --source include/have_debug.inc
3 --source include/have_partition.inc
4
5 --echo #
6 --echo # Bug#19904003 INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG=1
7 --echo # CAUSES INFINITE PAGE SPLIT
8 --echo #
9
10 SET GLOBAL innodb_limit_optimistic_insert_debug=1;
11 CREATE TABLE t1(c1 INT PRIMARY KEY) ENGINE=InnoDB
12 PARTITION BY HASH (c1) PARTITIONS 15;
13 DROP TABLE t1;
14
15 SET GLOBAL innodb_limit_optimistic_insert_debug=0;
16
17 --echo #
18 --echo # Bug#25082593 FOREIGN KEY VALIDATION DOESN'T NEED
19 --echo # TO ACQUIRE GAP LOCK IN READ COMMITTED
20 --echo #
21
22 SET GLOBAL innodb_limit_optimistic_insert_debug=2;
23
24 CREATE TABLE t1(col1 INT PRIMARY KEY) ENGINE=INNODB;
25
26 CREATE TABLE t2(col1 INT PRIMARY KEY, col2 INT NOT NULL,
27 FOREIGN KEY(col2) REFERENCES t1(col1)) ENGINE=INNODB;
28
29 INSERT INTO t1 VALUES(1), (3), (4);
30
31 connect (con1,localhost,root);
32
33 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
34 START TRANSACTION;
35 INSERT INTO t2 VALUES(1, 3);
36
37 connection default;
38 START TRANSACTION;
39
40 INSERT INTO t1 VALUES(2);
41
42 disconnect con1;
43
44 SET GLOBAL innodb_limit_optimistic_insert_debug=0;
45
46 DROP TABLE t2;
47 DROP TABLE t1;