drop table if exists t1,t2;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;set autocommit=0;update t2 set x = 1 where id = 0;select x from t1 where id = 0;select x from t2 where id = 0;ERROR 40001: Deadlock found when trying to get lock; try restarting transactioncommit;x1commit;select * from t1;id	x0	1select * from t2;id	x0	1commit;select * from t1;id	x0	1select * from t2;id	x0	1commit;drop table t1,t2;