← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/innodb-semi-consistent.test

  • Committer: Monty Taylor
  • Date: 2008-11-16 23:47:43 UTC
  • mto: (584.1.10 devel)
  • mto: This revision was merged to the branch mainline in revision 589.
  • Revision ID: monty@inaugust.com-20081116234743-c38gmv0pa2kdefaj
Broke out cached_item.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/innodb-semi-consistent.test
13
13
create table t1(a int not null) engine=innodb;
14
14
insert into t1 values (1),(2),(3),(4),(5),(6),(7);
15
15
set autocommit=0;
16
 
# we have locks_unsafe_for_binlog on by default. this should work.
 
16
# this should lock the entire table
17
17
select * from t1 where a=3 lock in share mode;
18
18
connection b;
19
19
set session transaction isolation level read committed;
20
20
set autocommit=0;
 
21
-- error ER_LOCK_WAIT_TIMEOUT
21
22
update t1 set a=10 where a=5;
22
23
connection a;
23
24
commit;
32
33
update t1 set a=11 where a=6;
33
34
-- error ER_LOCK_WAIT_TIMEOUT
34
35
update t1 set a=12 where a=2;
 
36
-- error ER_LOCK_WAIT_TIMEOUT
35
37
update t1 set a=13 where a=1;
36
38
connection a;
37
39
commit;