← Back to branch summary

~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid-security

« back to all changes in this revision

Viewing changes to mysql-test/r/innodb_timeout_rollback.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 22:33:55 UTC
  • mto: (1.2.1) (37.1.1 lucid-security)
  • mto: This revision was merged to the branch mainline in revision 36.
  • Revision ID: package-import@ubuntu.com-20120222223355-ku1tb4r70osci6v2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/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 unsigned 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