oceanbase

1
drop table if exists t1,t2,t3,t4;
2
create table t1(id int primary key, money1 int);
3
insert into t1 values(1,100);
4
begin;
5
update t1 set money1 = money1+100 where id=2;
6
begin;
7
insert into t1 values(2,100);
8
commit;
9
ROLLBACK;
10
select * from t1;
11
id	money1
12
1	100
13
begin;
14
insert into t1 values(3,100);
15
commit;
16
begin;
17
update t1 set money1 = money1+100 where id=3;
18
set @@ob_trx_timeout=100000000;
19
begin;
20
set @@ob_query_timeout = 10000000;
21
delete from t1 where id = 3;
22
Got one of the listed errors
23
commit;
24
ROLLBACK;
25
select * from t1;
26
id	money1
27
1	100
28
3	200
29
drop table t1;
30