diff options
Diffstat (limited to '')
| -rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/r/cons_snapshot_repeatable_read.result | 144 |
1 files changed, 144 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/r/cons_snapshot_repeatable_read.result b/storage/rocksdb/mysql-test/rocksdb/r/cons_snapshot_repeatable_read.result new file mode 100644 index 00000000..d9be37ee --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/r/cons_snapshot_repeatable_read.result @@ -0,0 +1,144 @@ +DROP TABLE IF EXISTS t1; +connect con1,localhost,root,,; +connect con2,localhost,root,,; +connection con1; +CREATE TABLE t1 (a INT, pk INT AUTO_INCREMENT PRIMARY KEY) ENGINE=ROCKSDB; +SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ; +START TRANSACTION WITH CONSISTENT SNAPSHOT; +ERROR: 0 +connection con2; +select * from information_schema.rocksdb_dbstats where stat_type='DB_NUM_SNAPSHOTS'; +STAT_TYPE VALUE +DB_NUM_SNAPSHOTS 1 +connection con1; +COMMIT; +connection con2; +select * from information_schema.rocksdb_dbstats where stat_type='DB_NUM_SNAPSHOTS'; +STAT_TYPE VALUE +DB_NUM_SNAPSHOTS 0 +connection con1; +START TRANSACTION WITH CONSISTENT SNAPSHOT; +ERROR: 0 +connection con2; +INSERT INTO t1 (a) VALUES (1); +connection con1; +# If consistent read works on this isolation level (REPEATABLE READ), the following SELECT should not return the value we inserted (1) +SELECT a FROM t1; +a +COMMIT; +connection default; +disconnect con1; +disconnect con2; +DROP TABLE t1; +connect con1,localhost,root,,; +connect con2,localhost,root,,; +connection con1; +CREATE TABLE r1 (id int primary key, value int, value2 int) engine=ROCKSDB; +SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ; +insert into r1 values (1,1,1),(2,2,2),(3,3,3),(4,4,4); +BEGIN; +connection con2; +INSERT INTO r1 values (5,5,5); +connection con1; +SELECT * FROM r1; +id value value2 +1 1 1 +2 2 2 +3 3 3 +4 4 4 +5 5 5 +connection con2; +INSERT INTO r1 values (6,6,6); +connection con1; +SELECT * FROM r1; +id value value2 +1 1 1 +2 2 2 +3 3 3 +4 4 4 +5 5 5 +COMMIT; +SELECT * FROM r1; +id value value2 +1 1 1 +2 2 2 +3 3 3 +4 4 4 +5 5 5 +6 6 6 +START TRANSACTION WITH CONSISTENT SNAPSHOT; +ERROR: 0 +connection con2; +INSERT INTO r1 values (7,7,7); +connection con1; +SELECT * FROM r1; +id value value2 +1 1 1 +2 2 2 +3 3 3 +4 4 4 +5 5 5 +6 6 6 +connection con2; +INSERT INTO r1 values (8,8,8); +connection con1; +SELECT * FROM r1; +id value value2 +1 1 1 +2 2 2 +3 3 3 +4 4 4 +5 5 5 +6 6 6 +COMMIT; +SELECT * FROM r1; +id value value2 +1 1 1 +2 2 2 +3 3 3 +4 4 4 +5 5 5 +6 6 6 +7 7 7 +8 8 8 +START TRANSACTION WITH CONSISTENT SNAPSHOT; +ERROR: 0 +connection con2; +INSERT INTO r1 values (9,9,9); +connection con1; +START TRANSACTION WITH CONSISTENT SNAPSHOT; +ERROR: 0 +connection con2; +INSERT INTO r1 values (10,10,10); +connection con1; +SELECT * FROM r1; +id value value2 +1 1 1 +2 2 2 +3 3 3 +4 4 4 +5 5 5 +6 6 6 +7 7 7 +8 8 8 +9 9 9 +START TRANSACTION WITH CONSISTENT SNAPSHOT; +ERROR: 0 +INSERT INTO r1 values (11,11,11); +ERROR: 4059 +SELECT * FROM r1; +id value value2 +1 1 1 +2 2 2 +3 3 3 +4 4 4 +5 5 5 +6 6 6 +7 7 7 +8 8 8 +9 9 9 +10 10 10 +drop table r1; +connection default; +disconnect con1; +disconnect con2; |