1
drop table if exists t1;
3
Note 1051 Unknown table 't1'
4
create table t1 (id int, index (id)) engine = pbxt;
5
insert into t1 values (1), (2), (3), (4), (5);
7
select * from t1 where id < 5 for update;
13
update t1 set id = 8 where id = 5;
14
update t1 set id = 8 where id = 4;
16
Id User Host db Command Time State Info Progress
17
x root x test Query x NULL show processlist 0.000
18
x root x test Query x Searching rows for update update t1 set id = 8 where id = 4 0.000
27
drop table if exists t1;
28
create table t1 (id int) engine = pbxt;
29
insert into t1 values (1), (2), (3), (4), (5);
31
select * from t1 where id > 10 for update;
42
drop table if exists t1;
43
create table t1 (id int, index (id)) engine = pbxt;
44
insert into t1 values (1), (2), (3), (4), (5);
46
select * from t1 where id = 5 for update;
49
update t1 set id = 8 where id < 4;
50
update t1 set id = 8 where id = 5;
52
Id User Host db Command Time State Info Progress
53
x root x test Query x NULL show processlist 0.000
54
x root x test Query x Searching rows for update update t1 set id = 8 where id = 5 0.000
63
drop table if exists t1;
64
create table t1 (id int, index (id)) engine = pbxt;
65
insert into t1 values (1), (2), (3), (4), (5);
66
select * from t1 for update;
74
drop table if exists t1;
75
create table t1 (id int, index (id)) engine = pbxt;
76
insert into t1 values (1), (2), (3), (4), (5);
77
create procedure p1 ()
79
select * from t1 for update;