Debian Codegraph @

mysql-test/suite/innodb/r/innodb-autoinc-61209.result

raw
1 DROP TABLE IF EXISTS bug_61209;
2 CREATE TABLE bug_61209 (a INT auto_increment, PRIMARY KEY(a)) ENGINE=InnoDB;
3 INSERT INTO bug_61209 VALUES (), (), (), ();
4 connect con1,localhost,root,,;
5 connect con2,localhost,root,,;
6 connection con1;
7 SET SESSION auto_increment_increment=3;
8 SET SESSION auto_increment_offset=2;
9 SELECT GET_LOCK('a', 9);
10 GET_LOCK('a', 9)
11 1
12 connection con2;
13 SET SESSION auto_increment_increment=3;
14 SET SESSION auto_increment_offset=2;
15 INSERT INTO bug_61209 (a) VALUES (NULL), (NULL), (NULL + GET_LOCK('a', 10));
16 connection con1;
17 INSERT INTO bug_61209 (a) VALUES (NULL), (NULL), (NULL);
18 SELECT RELEASE_LOCK('a');
19 RELEASE_LOCK('a')
20 1
21 connection con2;
22 DROP TABLE bug_61209;