1
--source include/have_tokudb.inc
3
# Record inconsistency.
6
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
9
DROP TABLE IF EXISTS foo;
12
#do some sanity checks that queries with disable_prefetching ON work
14
create table foo (a int, b int, primary key (a))engine=TokuDB;
15
insert into foo values (1,10),(2,20),(3,30),(4,40),(5,50);
16
set session tokudb_disable_prefetching=ON;
19
select * from foo where a=1;
20
select * from foo where a>1;
22
select * from foo where a > 1 for update;
24
set session transaction isolation level serializable;
26
select * from foo where a=1;
27
select * from foo where a>1;
29
select * from foo where a > 1 for update;