1set session transaction isolation level repeatable read;
2SET DEFAULT_STORAGE_ENGINE = 'tokudb';
3# Establish connection conn1 (user = root)
4connect  conn1,localhost,root,,;
5DROP TABLE IF EXISTS foo;
6connection conn1;
7set session transaction isolation level repeatable read;
8create table foo (a int, b int, primary key (a))engine=TokuDB;
9show create table foo;
10Table	Create Table
11foo	CREATE TABLE `foo` (
12  `a` int(11) NOT NULL,
13  `b` int(11) DEFAULT NULL,
14  PRIMARY KEY (`a`)
15) ENGINE=TokuDB DEFAULT CHARSET=latin1
16insert into foo values (1,1);
17begin;
18select * from foo;
19a	b
201	1
21connection default;
22begin;
23select * from foo;
24a	b
251	1
26connection conn1;
27replace into foo values (1,100), (2,200);
28#transaction that did the insert about to read
29select * from foo;
30a	b
311	100
322	200
33connection default;
34#this should read just (1,1)
35select * from foo;
36a	b
371	1
38connection conn1;
39commit;
40# this should read 2 values, (1,100) and (2,200)
41select * from foo;
42a	b
431	100
442	200
45connection default;
46#this should read just (1,1)
47select * from foo;
48a	b
491	1
50commit;
51connection default;
52disconnect conn1;
53connection default;
54set session transaction isolation level serializable;
55DROP TABLE foo;
56