oceanbase

1
drop table if exists t1;
2
create table t1(pk int primary key, c1 int);
3
insert into t1 values(1,1);
4
begin;
5
select *  from t1   where pk=1 for update;
6
pk	c1
7
1	1
8
update t1 set c1=c1+1 where pk=1;
9
begin;
10
select *  from t1  where t1.pk=1 for update;
11
commit;
12
pk	c1
13
1	2
14
update t1 set c1=c1+1 where pk=1;
15
commit;
16
select * from t1;
17
pk	c1
18
1	3
19