1
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
2
# Establish connection conn1 (user = root)
3
DROP TABLE IF EXISTS foo;
4
set session transaction isolation level repeatable read;
5
create table foo (a int, b int, c int, primary key (a))engine=TokuDB;
6
insert into foo values (1,10,100),(2,20,200),(3,30,300),(4,40,400);
8
# should read all four values
15
set session transaction isolation level repeatable read;
16
set session tokudb_load_save_space=1;
17
alter table foo add index (b);
18
# should read all four values
26
select sum(b) from foo;
27
ERROR HY000: Table definition has changed, please retry transaction
30
select sum(b) from foo;
33
set session transaction isolation level serializable;