1# ticket 895 is a query optimization problem with the primary key 2 3--source include/have_tokudb.inc 4SET DEFAULT_STORAGE_ENGINE = 'tokudb'; 5 6--echo # Establish connection conn1 (user = root) 7connect (conn1,localhost,root,,); 8 9--disable_warnings 10DROP TABLE IF EXISTS foo,foo1; 11--enable_warnings 12 13connection default; 14set session transaction isolation level repeatable read; 15create table foo (a int) engine=TokuDB; 16show create table foo; 17begin; 18select * from foo; 19 20connection conn1; 21set session transaction isolation level repeatable read; 22create table foo1(a int) engine=TokuDB; 23insert into foo1 values(1); 24 25connection default; 26--error ER_TABLE_DEF_CHANGED 27select * from foo1; 28 29connection default; 30disconnect conn1; 31 32connection default; 33# Final cleanup. 34set session transaction isolation level serializable; 35DROP TABLE foo,foo1;