~drizzle-trunk/drizzle/development

-- source include/have_innodb.inc

--disable_warnings

drop table if exists t1;

--enable_warnings

connect (a,localhost,root,,);

connect (b,localhost,root,,);

#

# BUG#11238 - in prelocking mode SELECT .. FOR UPDATE is changed to

# non-blocking SELECT

#

create table t1 (col1 integer primary key, col2 integer) engine=innodb;

insert t1 values (1,100);

start transaction;

select col2 from t1 where col1=1 for update;

connection b;

send update t1 set col2=0 where col1=1;

connection default;

select * from t1;

connection a;

rollback;

connection b;

reap;

rollback;

connection default;

drop table t1;

disconnect a;

disconnect b;