1SET DEFAULT_STORAGE_ENGINE = 'tokudb'; 2# Establish connection conn1 (user = root) 3DROP TABLE IF EXISTS foo; 4set session transaction isolation level repeatable read; 5create table foo (a int, b int, c int, primary key (a))engine=TokuDB; 6insert into foo values (1,10,100),(2,20,200),(3,30,300),(4,40,400); 7begin; 8# should read all four values 9select * from foo; 10a b c 111 10 100 122 20 200 133 30 300 144 40 400 15set session transaction isolation level repeatable read; 16set session tokudb_load_save_space=1; 17alter table foo add index (b); 18# should read all four values 19select * from foo; 20a b c 211 10 100 222 20 200 233 30 300 244 40 400 25# should fail 26select sum(b) from foo; 27ERROR HY000: Table definition has changed, please retry transaction 28commit; 29# should return 100 30select sum(b) from foo; 31sum(b) 32100 33set session transaction isolation level serializable; 34DROP TABLE foo; 35