1
drop table if exists t1;
2
create table t1(a int primary key, b int, c int, unique(b)) engine = ndb;
3
insert into t1 values (2,2,2);
4
insert into t1 values (3,3,3);
5
insert into t1 values (4,4,4);
7
insert into t1 values (1,1,1);
9
update t1 set c = 2 where b = 1;
10
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
14
create table t1(a int primary key, b int, c int, key(b)) engine = ndb;
15
insert into t1 values (2,2,2);
16
insert into t1 values (3,3,3);
17
insert into t1 values (4,4,4);
19
insert into t1 values (1,1,1);
21
update t1 set c = 2 where b = 1;
22
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
27
create table t1(a int primary key, b int, c int, key(b)) engine = ndb;
28
insert into t1 values (1,1,1);
29
insert into t1 values (2,2,2);
30
insert into t1 values (3,3,3);
31
insert into t1 values (4,4,4);
33
update t1 set c = 10 where a = 1;
34
update t1 set c = 20 where a = 1;
35
update t1 set c = 30 where a = 1;
37
select * from t1 where b >= 1 order by b;
44
select * from t1 where b >= 1 order by b;
51
delete from t1 where a = 1;
53
select * from t1 where b >= 1 order by b;
59
select * from t1 where b >= 1 order by b;
68
select * from t1 where b >= 1 order by b;
74
select * from t1 where b >= 1 order by b;
81
insert into t1 values (1,1,1);
82
update t1 set c = 10 where a = 1;
83
update t1 set c = 20 where a = 1;
84
update t1 set c = 30 where a = 1;
86
select * from t1 where b >= 1 order by b;
93
select * from t1 where b >= 1 order by b;