oceanbase

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