1SET DEFAULT_STORAGE_ENGINE = 'tokudb';
2# Establish connection conn1 (user = root)
3connect  conn1,localhost,root,,;
4DROP TABLE IF EXISTS foo,foo1;
5connection default;
6set session transaction isolation level repeatable read;
7create table foo (a int) engine=TokuDB;
8show create table foo;
9Table	Create Table
10foo	CREATE TABLE `foo` (
11  `a` int(11) DEFAULT NULL
12) ENGINE=TokuDB DEFAULT CHARSET=latin1
13begin;
14select * from foo;
15a
16connection conn1;
17set session transaction isolation level repeatable read;
18create table foo1(a int, b int, c int, primary key (a)) engine=TokuDB;
19insert into foo1 values (1,10,100),(2,20,200),(3,30,300),(4,40,400),(5,50,500);
20connection default;
21select a from foo1;
22ERROR HY000: Table definition has changed, please retry transaction
23select a from foo1 order by a desc;
24ERROR HY000: Table definition has changed, please retry transaction
25select * from foo1 where a=3;
26ERROR HY000: Table definition has changed, please retry transaction
27select * from foo1 where a>3;
28ERROR HY000: Table definition has changed, please retry transaction
29select * from foo1 where a>3 order by a desc;
30ERROR HY000: Table definition has changed, please retry transaction
31select * from foo1;
32ERROR HY000: Table definition has changed, please retry transaction
33connection default;
34disconnect conn1;
35connection default;
36set session transaction isolation level serializable;
37DROP TABLE foo,foo1;
38