1
# ticket 895 is a query optimization problem with the primary key
3
#--source include/have_tokudb.inc
4
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
6
--echo # Establish connection conn1 (user = root)
7
connect (conn1,localhost,root,,);
10
DROP TABLE IF EXISTS foo;
14
create table foo (a int)engine=TokuDB;
15
show create table foo;
16
insert into foo values (1),(2),(3);
18
insert into foo values (4);
21
set session transaction isolation level repeatable read;
26
set session transaction isolation level read committed;
31
set session transaction isolation level read uncommitted;
36
set session transaction isolation level serializable;
38
--error ER_LOCK_WAIT_TIMEOUT
41
--echo # should be NULL
51
set session transaction isolation level serializable;