diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/mvcc-9.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/r/mvcc-9.result | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/mvcc-9.result b/storage/tokudb/mysql-test/tokudb/r/mvcc-9.result index 7dcae265518..fe6be9b24cb 100644 --- a/storage/tokudb/mysql-test/tokudb/r/mvcc-9.result +++ b/storage/tokudb/mysql-test/tokudb/r/mvcc-9.result @@ -1,6 +1,12 @@ SET DEFAULT_STORAGE_ENGINE = 'tokudb'; # Establish connection conn1 (user = root) +connect conn1,localhost,root,,; +connect conn2,localhost,root,,; +connect conn3,localhost,root,,; +connect conn4,localhost,root,,; +connect conn5,localhost,root,,; DROP TABLE IF EXISTS foo; +connection default; create table foo (a int, b varchar (100), primary key (a)) engine=TokuDB; show create table foo; Table Create Table @@ -9,24 +15,31 @@ foo CREATE TABLE `foo` ( `b` varchar(100) DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 +connection conn1; set session transaction isolation level repeatable read; begin; select * from foo; a b +connection default; replace into foo values (1, "a"); +connection conn2; set session transaction isolation level repeatable read; begin; select * from foo; a b 1 a +connection default; replace into foo values (1,"ab"), (2, "ab"); +connection conn3; set session transaction isolation level repeatable read; begin; select * from foo; a b 1 ab 2 ab +connection default; replace into foo values (1,"abc"),(2,"abc"),(3, "abc"); +connection conn4; set session transaction isolation level repeatable read; begin; select * from foo; @@ -34,7 +47,9 @@ a b 1 abc 2 abc 3 abc +connection default; replace into foo values (1,"abcd"),(2,"abcd"),(3, "abcd"),(4, "abcd"); +connection conn5; set session transaction isolation level repeatable read; begin; select * from foo; @@ -43,24 +58,29 @@ a b 2 abcd 3 abcd 4 abcd +connection conn1; select * from foo; a b commit; +connection conn2; select * from foo; a b 1 a commit; +connection conn3; select * from foo; a b 1 ab 2 ab commit; +connection conn4; select * from foo; a b 1 abc 2 abc 3 abc commit; +connection conn5; select * from foo; a b 1 abcd @@ -68,5 +88,12 @@ a b 3 abcd 4 abcd commit; +connection default; +disconnect conn1; +disconnect conn2; +disconnect conn3; +disconnect conn4; +disconnect conn5; +connection default; set session transaction isolation level serializable; DROP TABLE foo; |