diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb/r/autoinc_vars_thread.result')
| -rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/r/autoinc_vars_thread.result | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/r/autoinc_vars_thread.result b/storage/rocksdb/mysql-test/rocksdb/r/autoinc_vars_thread.result new file mode 100644 index 00000000..9331b4e2 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/r/autoinc_vars_thread.result @@ -0,0 +1,39 @@ +#--------------------------- +# 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_vars2 SIGNAL go2'; +SET debug_sync='rocksdb.autoinc_vars SIGNAL parked1 WAIT_FOR go1'; +INSERT INTO t1 VALUES(NULL); +connection default; +SET debug_sync='now WAIT_FOR parked1'; +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 parked2'; +SET debug_sync='now SIGNAL go1'; +connection con3; +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; |