1SET DEFAULT_STORAGE_ENGINE = 'tokudb'; 2# Establish connection conn1 (user = root) 3connect conn1,localhost,root,,; 4DROP TABLE IF EXISTS foo; 5connection default; 6set session transaction isolation level serializable; 7create table foo (a int, b varchar(10), primary key (a))engine=TokuDB; 8insert into foo values (1,"a"); 9connection conn1; 10set session transaction isolation level repeatable read; 11begin; 12# should read ONLY (1,"a") 13select * from foo; 14a b 151 a 16connection default; 17delete from foo where a=1; 18insert into foo values (2,"bb"); 19# should read ONLY (2,"bb") 20begin; 21select * from foo; 22a b 232 bb 24connection conn1; 25# should read ONLY (1,"a") 26select * From foo; 27a b 281 a 29commit; 30insert into foo values ("101000","asdf"); 31ERROR HY000: Lock wait timeout exceeded; try restarting transaction 32connection default; 33commit; 34disconnect conn1; 35connection default; 36set session transaction isolation level serializable; 37DROP TABLE foo; 38