diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/mvcc-29.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/r/mvcc-29.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/mvcc-29.result b/storage/tokudb/mysql-test/tokudb/r/mvcc-29.result index 5c02babaed3..994b906e2a2 100644 --- a/storage/tokudb/mysql-test/tokudb/r/mvcc-29.result +++ b/storage/tokudb/mysql-test/tokudb/r/mvcc-29.result @@ -1,10 +1,14 @@ SET DEFAULT_STORAGE_ENGINE = 'tokudb'; # Establish connection conn1 (user = root) +connect conn1,localhost,root,,; DROP TABLE IF EXISTS foo; +connection conn1; set session transaction isolation level repeatable read; +connection default; set session transaction isolation level repeatable read; create table foo (a int, b int, primary key (a))engine=TokUDB; insert into foo values (1,1),(2,2),(3,3),(4,4),(5,5),(10,10),(20,20),(30,30),(40,40),(50,50); +connection conn1; begin; select * from foo; a b @@ -22,6 +26,7 @@ a b explain select * from foo where a > 1; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE foo range PRIMARY PRIMARY 4 NULL 9 Using where +connection default; delete from foo where a > 5; # number of rows should be 9 explain select * from foo where a > 1; @@ -34,6 +39,7 @@ a b 3 3 4 4 5 5 +connection conn1; # number of rows should be 9 explain select * from foo where a > 1; id select_type table type possible_keys key key_len ref rows Extra @@ -51,5 +57,8 @@ a b 40 40 50 50 commit; +connection default; +disconnect conn1; +connection default; set session transaction isolation level serializable; DROP TABLE foo; |