1SET DEFAULT_STORAGE_ENGINE = 'tokudb'; 2# Establish connection conn1 (user = root) 3connect conn1,localhost,root,,; 4DROP TABLE IF EXISTS foo; 5connection default; 6set session tokudb_load_save_space=0; 7create table foo (a int) engine=TokuDB; 8show create table foo; 9Table Create Table 10foo CREATE TABLE `foo` ( 11 `a` int(11) DEFAULT NULL 12) ENGINE=TokuDB DEFAULT CHARSET=latin1 13insert into foo values (1),(2),(3); 14connection conn1; 15set session transaction isolation level repeatable read; 16begin; 17# should return (1),(2),(3) 18select * from foo; 19a 201 212 223 23connection default; 24delete from foo; 25insert into foo values (4); 26# should return (4) 27select * from foo; 28a 294 30connection conn1; 31# should return (1),(2),(3) 32select * from foo; 33a 341 352 363 37connection default; 38disconnect conn1; 39connection default; 40set session transaction isolation level serializable; 41DROP TABLE foo; 42