~drizzle-trunk/drizzle/development

Changed the semi-consistent test. With innodb_locks_unsafe_for_binlog, the behavior is different here (no next-key-locking for us)

added added

removed removed

set session transaction isolation level read committed;

set autocommit=0;

update t1 set a=10 where a=5;

ERROR HY000: Lock wait timeout exceeded; try restarting transaction

commit;

update t1 set a=10 where a=5;

select * from t1 where a=2 for update;

update t1 set a=12 where a=2;

ERROR HY000: Lock wait timeout exceeded; try restarting transaction

update t1 set a=13 where a=1;

ERROR HY000: Lock wait timeout exceeded; try restarting transaction

commit;

update t1 set a=14 where a=1;

commit;

select * from t1;