diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/mvcc-23.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/r/mvcc-23.result | 59 |
1 files changed, 59 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/mvcc-23.result b/storage/tokudb/mysql-test/tokudb/r/mvcc-23.result new file mode 100644 index 00000000000..9ea3c631d17 --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb/r/mvcc-23.result @@ -0,0 +1,59 @@ +SET DEFAULT_STORAGE_ENGINE = 'tokudb'; +# Establish connection conn1 (user = root) +DROP TABLE IF EXISTS foo; +create table foo (a int, b varchar (100), primary key (a)) engine=TokuDB; +show create table foo; +Table Create Table +foo CREATE TABLE `foo` ( + `a` int(11) NOT NULL DEFAULT '0', + `b` varchar(100) DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=TokuDB DEFAULT CHARSET=latin1 +set session transaction isolation level repeatable read; +begin; +select * from foo; +a b +replace into foo values (1, "aGARBAGE"); +replace into foo values (1, "a"); +set session transaction isolation level repeatable read; +begin; +select * from foo; +a b +1 a +replace into foo values (1, "delete1Garbage"); +delete from foo; +set session transaction isolation level repeatable read; +begin; +select * from foo; +a b +replace into foo values (1,"abcGARBAGE"); +replace into foo values (1,"abc"); +set session transaction isolation level repeatable read; +begin; +select * from foo; +a b +1 abc +delete from foo; +set session transaction isolation level repeatable read; +begin; +select * from foo; +a b +select * from foo; +a b +commit; +select * from foo; +a b +1 a +commit; +select * from foo; +a b +commit; +select * from foo; +a b +1 abc +commit; +select * from foo; +a b +commit; +set session transaction isolation level serializable; +DROP TABLE foo; |