summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/tokudb/r/mvcc-28.result
diff options
context:
space:
mode:
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/mvcc-28.result')
-rw-r--r--storage/tokudb/mysql-test/tokudb/r/mvcc-28.result8
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;