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