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;