1SET DEFAULT_STORAGE_ENGINE = 'tokudb'; 2# Establish connection conn1 (user = root) 3connect conn1,localhost,root,,; 4DROP TABLE IF EXISTS foo; 5connection default; 6set session transaction isolation level repeatable read; 7create table foo (a int, b int, primary key (a))engine=TokuDB; 8show create table foo; 9Table Create Table 10foo CREATE TABLE `foo` ( 11 `a` int(11) NOT NULL, 12 `b` int(11) DEFAULT NULL, 13 PRIMARY KEY (`a`) 14) ENGINE=TokuDB DEFAULT CHARSET=latin1 15insert into foo values (1,100); 16select * from foo; 17a b 181 100 19begin; 20insert into foo values (100,100); 21# should see (1,100) 22select * from foo; 23a b 241 100 25100 100 26connection conn1; 27set session transaction isolation level repeatable read; 28# should NOT see (1,100) 29select * from foo; 30a b 311 100 32connection default; 33# should see (1,100) 34select * from foo; 35a b 361 100 37100 100 38rollback; 39# should NOT see (1,100) 40select * from foo; 41a b 421 100 43disconnect conn1; 44connection default; 45set session transaction isolation level serializable; 46DROP TABLE foo; 47