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 serializable;
7create table foo (a int, b varchar(10), primary key (a))engine=TokuDB;
8insert into foo values (1,"a");
9connection conn1;
10set session transaction isolation level repeatable read;
11begin;
12# should read ONLY (1,"a")
13select * from foo;
14a	b
151	a
16connection default;
17delete from foo where a=1;
18insert into foo values (2,"bb");
19# should read ONLY (2,"bb")
20begin;
21select * from foo;
22a	b
232	bb
24connection conn1;
25# should read ONLY (1,"a")
26select * From foo;
27a	b
281	a
29commit;
30insert into foo values ("101000","asdf");
31ERROR HY000: Lock wait timeout exceeded; try restarting transaction
32connection default;
33commit;
34disconnect conn1;
35connection default;
36set session transaction isolation level serializable;
37DROP TABLE foo;
38