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