diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/mvcc-22.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/r/mvcc-22.result | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/mvcc-22.result b/storage/tokudb/mysql-test/tokudb/r/mvcc-22.result index 412f5afb9e0..b0d557b24fe 100644 --- a/storage/tokudb/mysql-test/tokudb/r/mvcc-22.result +++ b/storage/tokudb/mysql-test/tokudb/r/mvcc-22.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,57 +15,72 @@ 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,"aGARBAGE"); 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,"abGARBAGE"); replace into foo values (1,"ab"); +connection conn3; set session transaction isolation level repeatable read; begin; select * from foo; a b 1 ab +connection default; replace into foo values (1,"abcGARBAGE"); replace into foo values (1,"abc"); +connection conn4; set session transaction isolation level repeatable read; begin; select * from foo; a b 1 abc +connection default; replace into foo values (1,"abcdGARBAGE"); replace into foo values (1,"abcd"); +connection conn5; set session transaction isolation level repeatable read; begin; select * from foo; a b 1 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 commit; +connection conn4; select * from foo; a b 1 abc commit; +connection conn5; select * from foo; a b 1 abcd commit; +connection default; select * from foo; a b 1 abcd @@ -67,5 +88,11 @@ replace into foo values (1,"1"); select * from foo; a b 1 1 +disconnect conn1; +disconnect conn2; +disconnect conn3; +disconnect conn4; +disconnect conn5; +connection default; set session transaction isolation level serializable; DROP TABLE foo; |