← 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: Jay Pipes
  • Date: 2009-02-21 16:00:06 UTC
  • mto: (907.1.1 trunk-with-temporal)
  • mto: This revision was merged to the branch mainline in revision 908.
  • Revision ID: jpipes@serialcoder-20090221160006-vnk3wt4qbcz62eru
Removes the TIME column type and related time functions.

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;