text: # ticket 895 is a query optimization problem with the primary key
  
  --source include/have_tokudb.inc
  SET DEFAULT_STORAGE_ENGINE = 'tokudb';
  
  --echo # Establish connection conn1 (user = root)
  connect (conn1,localhost,root,,);
  
  --disable_warnings
  DROP TABLE IF EXISTS foo;
  --enable_warnings
  
  connection default;
  set session tokudb_load_save_space=1;
  create table foo (a int) engine=TokuDB;
  show create table foo;
  insert into foo values (1),(2),(3);
  
  connection conn1;
  set session transaction isolation level repeatable read;
  begin;
  --echo # should return (1),(2),(3)
  select * from foo;
  
  connection default;
  delete from foo;
  insert into foo values (4);
  --echo # should return (4)
  select * from foo;
  
  connection conn1;
  --echo # should return (1),(2),(3)
  select * from foo;
  
  
  connection default;
  disconnect conn1;
  
  connection default;
  # Final cleanup.
  set session transaction isolation level serializable;
  DROP TABLE foo;