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