1# Establish connection conn1 (user = root)
2connect  conn1,localhost,root,,;
3SET DEFAULT_STORAGE_ENGINE = 'tokudb';
4DROP TABLE IF EXISTS foo,foo_isam;
5connection conn1;
6set session transaction isolation level read uncommitted;
7create table foo ( a int, b int, primary key (a));
8insert into foo values (1,1),(2,2),(3,1),(4,3);
9select * from foo;
10a	b
111	1
122	2
133	1
144	3
15begin;
16update foo set b=10 where b=1;
17select * from foo;
18a	b
191	10
202	2
213	10
224	3
23connection default;
24insert into foo values (5,5);
25ERROR HY000: Lock wait timeout exceeded; try restarting transaction
26connection conn1;
27rollback;
28select * from foo;
29a	b
301	1
312	2
323	1
334	3
34begin;
35delete from foo where b=2;
36select * from foo;
37a	b
381	1
393	1
404	3
41connection default;
42insert into foo values (5,5);
43ERROR HY000: Lock wait timeout exceeded; try restarting transaction
44connection conn1;
45rollback;
46select * from foo;
47a	b
481	1
492	2
503	1
514	3
52create table foo_isam (a int, b int)engine=MyISAM;
53begin;
54insert into foo_isam select * from foo;
55connection default;
56insert into foo values (5,5);
57select * from foo;
58a	b
591	1
602	2
613	1
624	3
635	5
64connection conn1;
65commit;
66connection default;
67disconnect conn1;
68connection default;
69set session transaction isolation level serializable;
70DROP TABLE foo, foo_isam;
71