From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:00:34 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- .../suite/innodb/r/innodb-autoinc-61209.result | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 mysql-test/suite/innodb/r/innodb-autoinc-61209.result (limited to 'mysql-test/suite/innodb/r/innodb-autoinc-61209.result') diff --git a/mysql-test/suite/innodb/r/innodb-autoinc-61209.result b/mysql-test/suite/innodb/r/innodb-autoinc-61209.result new file mode 100644 index 00000000..f01008a8 --- /dev/null +++ b/mysql-test/suite/innodb/r/innodb-autoinc-61209.result @@ -0,0 +1,22 @@ +DROP TABLE IF EXISTS bug_61209; +CREATE TABLE bug_61209 (a INT auto_increment, PRIMARY KEY(a)) ENGINE=InnoDB; +INSERT INTO bug_61209 VALUES (), (), (), (); +connect con1,localhost,root,,; +connect con2,localhost,root,,; +connection con1; +SET SESSION auto_increment_increment=3; +SET SESSION auto_increment_offset=2; +SELECT GET_LOCK('a', 9); +GET_LOCK('a', 9) +1 +connection con2; +SET SESSION auto_increment_increment=3; +SET SESSION auto_increment_offset=2; +INSERT INTO bug_61209 (a) VALUES (NULL), (NULL), (NULL + GET_LOCK('a', 10)); +connection con1; +INSERT INTO bug_61209 (a) VALUES (NULL), (NULL), (NULL); +SELECT RELEASE_LOCK('a'); +RELEASE_LOCK('a') +1 +connection con2; +DROP TABLE bug_61209; -- cgit v1.2.3