| 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; |