1
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
2
# Establish connection conn1 (user = root)
3
DROP TABLE IF EXISTS foo,bar;
4
set session transaction isolation level repeatable read;
5
create table foo (a int, b varchar (100), primary key (a))engine=TokuDB;
6
create table bar like foo;
9
foo CREATE TABLE `foo` (
10
`a` int(11) NOT NULL DEFAULT '0',
11
`b` varchar(100) DEFAULT NULL,
13
) ENGINE=TokuDB DEFAULT CHARSET=latin1
14
show create table bar;
16
bar CREATE TABLE `bar` (
17
`a` int(11) NOT NULL DEFAULT '0',
18
`b` varchar(100) DEFAULT NULL,
20
) ENGINE=TokuDB DEFAULT CHARSET=latin1
21
set session transaction isolation level repeatable read;
34
insert into foo values (1,"g");
36
replace into foo values (1,"ga");
37
replace into foo values (1,"gar");
38
replace into foo values (1,"garb");
39
replace into foo values (1,"aaaa");
40
# should have one value
53
set session transaction isolation level serializable;