EVOLUTION-MANAGER

Edit File: autoinc_vars_thread.result

#---------------------------
# two threads inserting simultaneously with increment > 1
# Issue #390
#---------------------------
CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY) ENGINE=rocksdb;
connect  con1, localhost, root,,;
SET auto_increment_increment = 2;
SET auto_increment_offset = 1;
INSERT INTO t1 VALUES(NULL);
connect  con2, localhost, root,,;
SET auto_increment_increment = 2;
SET auto_increment_offset = 1;
connect  con3, localhost, root,,;
connection con1;
SET debug_sync='rocksdb.autoinc_vars SIGNAL parked1 WAIT_FOR go1';
INSERT INTO t1 VALUES(NULL);
connection con2;
SET debug_sync='rocksdb.autoinc_vars SIGNAL parked2 WAIT_FOR go2';
INSERT INTO t1 VALUES(NULL);
connection default;
SET debug_sync='now WAIT_FOR parked1';
SET debug_sync='now WAIT_FOR parked2';
SET debug_sync='now SIGNAL go1';
connection con3;
SET debug_sync='now SIGNAL go2';
connection default;
connection con1;
connection con2;
connection default;
SET debug_sync='RESET';
disconnect con1;
disconnect con2;
SELECT * FROM t1;
a
1
3
5
DROP TABLE t1;