← 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: Brian Aker
  • Date: 2009-01-24 09:43:35 UTC
  • Revision ID: brian@gir-3.local-20090124094335-6qdtvc35gl5fvivz
Adding in an example singe thread scheduler

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/innodb-semi-consistent.result
9
9
set session transaction isolation level read committed;
10
10
set autocommit=0;
11
11
update t1 set a=10 where a=5;
 
12
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
12
13
commit;
13
14
update t1 set a=10 where a=5;
14
15
select * from t1 where a=2 for update;
20
21
update t1 set a=12 where a=2;
21
22
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
22
23
update t1 set a=13 where a=1;
 
24
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
23
25
commit;
24
26
update t1 set a=14 where a=1;
25
27
commit;
26
28
select * from t1;
27
29
a
28
 
13
 
30
14
29
31
2
30
32
3
31
33
4