bdb-deadlock.test

视频监控网络部分的协议ddns,的模块的实现代码,请大家大胆指正.

-- source include/have_bdb.inc

connect (con1,localhost,root,,);
connect (con2,localhost,root,,);

--disable_warnings
drop table if exists t1,t2;
--enable_warnings
connection con1;
create table t1 (id integer, x integer) engine=BDB;
create table t2 (id integer, x integer) engine=BDB;
insert into t1 values(0, 0);
insert into t2 values(0, 0);
set autocommit=0;
update t1 set x = 1 where id = 0;

connection con2;
set autocommit=0;
update t2 set x = 1 where id = 0;

# The following query should hang because con1 is locking the page
--send
select x from t1 where id = 0;

connection con1;
# This should generate a deadlock as we are trying to access a locked row
--send
select x from t2 where id = 0;

connection con2;
--error 1213
reap;
commit;

connection con1;
reap;
commit;

connection con2;
select * from t1;
select * from t2;
commit;

connection con1;
select * from t1;
select * from t2;
commit;

drop table t1,t2;

# End of 4.1 tests