oceanbase

1
drop table if exists t1,t2,t3,t4;
2
create table t1(id int primary key, money1 int);
3
insert into t1(id,money1) values(1,100);
4
create table t2(id int primary key, money1 int);
5
insert into t2(id,money1) values(1,100);
6
select id,money1 from t1;
7
id	money1
8
1	100
9
select id,money1 from t2;
10
id	money1
11
1	100
12
id1 - 100  id2 + 100
13
begin;
14
update t1 set money1 = money1-100 where id = 1;
15
update t2 set money1 = money1+100 where id = 1;
16
commit;
17
select id,money1 from t1;
18
id	money1
19
1	0
20
select id,money1 from t2;
21
id	money1
22
1	200
23
drop table t1;
24
drop table t2;
25
create table t1(id int primary key, money1 int);
26
insert into t1(id,money1) values(1,100);
27
create table t2(id int primary key, money1 int);
28
insert into t2(id,money1) values(1,100);
29
select id,money1 from t1;
30
id	money1
31
1	100
32
select id,money1 from t2;
33
id	money1
34
1	100
35
id1 - 100  id2 + 100
36
begin;
37
update t1 set money1 = money1-100 where id = 1;
38
update t2 set money1 = money1+100 where id = 1;
39
ERROR HY000: OceanBase server has gone away
40
commit;
41
ERROR HY000: OceanBase server has gone away
42
select id,money1 from t1;
43
id	money1
44
1	100
45
select id,money1 from t2;
46
id	money1
47
1	100
48
drop table t1;
49
drop table t2;
50