diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/mvcc-28.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/r/mvcc-28.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/mvcc-28.result b/storage/tokudb/mysql-test/tokudb/r/mvcc-28.result index 7562495484c..ce099f5f27a 100644 --- a/storage/tokudb/mysql-test/tokudb/r/mvcc-28.result +++ b/storage/tokudb/mysql-test/tokudb/r/mvcc-28.result @@ -1,15 +1,19 @@ SET DEFAULT_STORAGE_ENGINE = 'tokudb'; # Establish connection conn1 (user = root) +connect conn1,localhost,root,,; DROP TABLE IF EXISTS foo; +connection default; set session transaction isolation level serializable; create table foo (a int, b varchar(10), primary key (a))engine=TokuDB; insert into foo values (1,"a"); +connection conn1; set session transaction isolation level repeatable read; begin; # should read ONLY (1,"a") select * from foo; a b 1 a +connection default; delete from foo where a=1; insert into foo values (2,"bb"); # should read ONLY (2,"bb") @@ -17,6 +21,7 @@ begin; select * from foo; a b 2 bb +connection conn1; # should read ONLY (1,"a") select * From foo; a b @@ -24,6 +29,9 @@ a b commit; insert into foo values ("101000","asdf"); ERROR HY000: Lock wait timeout exceeded; try restarting transaction +connection default; commit; +disconnect conn1; +connection default; set session transaction isolation level serializable; DROP TABLE foo; |