← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/innodb-semi-consistent.result

  • Committer: Mark Atwood
  • Date: 2008-10-03 01:39:40 UTC
  • mto: This revision was merged to the branch mainline in revision 437.
  • Revision ID: mark@fallenpegasus.com-20081003013940-mvefjo725dltz41h
rename logging_noop to logging_query

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/innodb-semi-consistent.result
1
1
drop table if exists t1;
2
 
SET @orig_lock_wait_timeout= @@innodb_lock_wait_timeout;
3
 
SET GLOBAL innodb_lock_wait_timeout=2;
4
2
set session transaction isolation level read committed;
5
3
create table t1(a int not null) engine=innodb;
6
4
insert into t1 values (1),(2),(3),(4),(5),(6),(7);
11
9
set session transaction isolation level read committed;
12
10
set autocommit=0;
13
11
update t1 set a=10 where a=5;
 
12
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
14
13
commit;
15
14
update t1 set a=10 where a=5;
16
15
select * from t1 where a=2 for update;
22
21
update t1 set a=12 where a=2;
23
22
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
24
23
update t1 set a=13 where a=1;
 
24
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
25
25
commit;
26
26
update t1 set a=14 where a=1;
27
27
commit;
28
28
select * from t1;
29
29
a
30
 
13
 
30
14
31
31
2
32
32
3
33
33
4
35
35
11
36
36
7
37
37
drop table t1;
38
 
SET GLOBAL innodb_lock_wait_timeout=@orig_lock_wait_timeout ;