diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/mvcc-5.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/r/mvcc-5.result | 50 |
1 files changed, 50 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/mvcc-5.result b/storage/tokudb/mysql-test/tokudb/r/mvcc-5.result new file mode 100644 index 00000000000..47204dcc7e1 --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb/r/mvcc-5.result @@ -0,0 +1,50 @@ +SET DEFAULT_STORAGE_ENGINE = 'tokudb'; +set session transaction isolation level repeatable read; +# Establish connection conn1 (user = root) +DROP TABLE IF EXISTS foo; +create table foo (a int, b int, primary key (a))engine=TokuDB; +show create table foo; +Table Create Table +foo CREATE TABLE `foo` ( + `a` int(11) NOT NULL DEFAULT '0', + `b` int(11) DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=TokuDB DEFAULT CHARSET=latin1 +insert into foo values (1,1); +set session transaction isolation level repeatable read; +begin; +# Should read just (1,1) +select * from foo; +a b +1 1 +set session transaction isolation level read committed; +begin; +# Should read just (1,1) +select * from foo; +a b +1 1 +replace into foo values (1,10),(2,20); +# Should read just (1,1) +select * from foo; +a b +1 1 +# Should read just (1,10), (2,20) +select * from foo; +a b +1 10 +2 20 +replace into foo values (1,100),(2,200),(3,300); +# Should read just (1,1) +select * from foo; +a b +1 1 +commit; +# Should read just (1,100), (2,200),(3,300) +select * from foo; +a b +1 100 +2 200 +3 300 +commit; +set session transaction isolation level serializable; +DROP TABLE foo; |