1
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
2
# Establish connection conn1 (user = root)
3
DROP TABLE IF EXISTS foo;
4
create table foo (a int, b varchar (100), primary key (a)) engine=TokuDB;
7
foo CREATE TABLE `foo` (
8
`a` int(11) NOT NULL DEFAULT '0',
9
`b` varchar(100) DEFAULT NULL,
11
) ENGINE=TokuDB DEFAULT CHARSET=latin1
12
set session transaction isolation level repeatable read;
16
replace into foo values (1, "a");
17
set session transaction isolation level repeatable read;
22
replace into foo values (1,"abGARBAGE"), (2, "abGARBAGE");
23
replace into foo values (1,"ab"), (2, "ab");
24
set session transaction isolation level repeatable read;
30
replace into foo values (1,"abcGARBAGE"),(2,"abcGARBAGE"),(3, "abcGARBAGE");
31
replace into foo values (1,"abc"),(2,"abc"),(3, "abc");
32
set session transaction isolation level repeatable read;
39
replace into foo values (1,"abcdGARBAGE"),(2,"abcdGARBAGE"),(3, "abcdGARBAGE"),(4, "abcdGARBAGE");
40
replace into foo values (1,"abcd"),(2,"abcd"),(3, "abcd"),(4, "abcd");
41
set session transaction isolation level repeatable read;
80
replace into foo values (1,"1"),(2,"2"),(3,"3"),(4,"4");
87
set session transaction isolation level serializable;