← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/innodb_timeout_rollback.result

  • Committer: Brian Aker
  • Date: 2008-09-04 19:31:00 UTC
  • Revision ID: brian@tangent.org-20080904193100-l849hgghfy4urj43
Changing default character set from this point on.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/innodb_timeout_rollback.result
1
 
drop table if exists t1;
2
 
show variables like 'innodb_rollback_on_timeout';
3
 
Variable_name   Value
4
 
innodb_rollback_on_timeout      ON
5
 
create table t1 (a int not null primary key) engine = innodb;
6
 
insert into t1 values (1);
7
 
commit;
8
 
begin work;
9
 
insert into t1 values (2);
10
 
select * from t1;
11
 
a
12
 
1
13
 
2
14
 
begin work;
15
 
insert into t1 values (5);
16
 
select * from t1;
17
 
a
18
 
1
19
 
5
20
 
insert into t1 values (2);
21
 
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
22
 
select * from t1;
23
 
a
24
 
1
25
 
commit;
26
 
select * from t1;
27
 
a
28
 
1
29
 
2
30
 
commit;
31
 
select * from t1;
32
 
a
33
 
1
34
 
2
35
 
drop table t1;
36
 
End of 5.0 tests