source include/have_tokudb.inc;
# ticket 895 is a query optimization problem with the primary key
SET DEFAULT_STORAGE_ENGINE = 'tokudb';

--disable_warnings
DROP TABLE IF EXISTS foo;
--enable_warnings

set session transaction isolation level repeatable read;
create table foo (a int);
select * from foo;
begin;
insert into foo values (1);
select * from foo;
rollback;
select * from foo;

set session transaction isolation level read committed;
begin;
insert into foo values (1);
select * from foo;
rollback;
select * from foo;

DROP TABLE foo;