diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/insert_debug.result')
-rw-r--r-- | mysql-test/suite/innodb/r/insert_debug.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/insert_debug.result b/mysql-test/suite/innodb/r/insert_debug.result index 0d176afa116..3ac9df58c16 100644 --- a/mysql-test/suite/innodb/r/insert_debug.result +++ b/mysql-test/suite/innodb/r/insert_debug.result @@ -9,3 +9,23 @@ PARTITION BY HASH (c1) PARTITIONS 15; DROP TABLE t1; SET GLOBAL innodb_change_buffering_debug=0; SET GLOBAL innodb_limit_optimistic_insert_debug=0; +# +# Bug#25082593 FOREIGN KEY VALIDATION DOESN'T NEED +# TO ACQUIRE GAP LOCK IN READ COMMITTED +# +SET GLOBAL innodb_limit_optimistic_insert_debug=2; +CREATE TABLE t1(col1 INT PRIMARY KEY) ENGINE=INNODB; +CREATE TABLE t2(col1 INT PRIMARY KEY, col2 INT NOT NULL, +FOREIGN KEY(col2) REFERENCES t1(col1)) ENGINE=INNODB; +INSERT INTO t1 VALUES(1), (3), (4); +connect con1,localhost,root; +SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; +START TRANSACTION; +INSERT INTO t2 VALUES(1, 3); +connection default; +START TRANSACTION; +INSERT INTO t1 VALUES(2); +disconnect con1; +SET GLOBAL innodb_limit_optimistic_insert_debug=0; +DROP TABLE t2; +DROP TABLE t1; |