oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
# owner: yuchen.wyc
5
# owner group: SQL1
6
# description: OUR GOAL: Make all this simple and effective!
7
--disable_warnings
8
drop table if exists t1,t2,t3,t4;
9
--enable_warnings
10

11
connect (conn1,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
12
connect (conn2,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
13
connect (conn3,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
14
connect (conn4,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
15

16
###
17
# account test
18
##
19
create table t1(id int primary key, money1 int);
20
insert into t1(id,money1) values(1,100);
21
create table t2(id int primary key, money1 int);
22
insert into t2(id,money1) values(1,100);
23

24
select id,money1 from t1;
25
select id,money1 from t2;
26

27
--echo id1 - 100  id2 + 100
28
connection conn1;
29
begin;
30
update t1 set money1 = money1-100 where id = 1;
31
update t2 set money1 = money1+100 where id = 1;
32
commit;
33

34

35
connection conn2;
36
select id,money1 from t1;
37
select id,money1 from t2;
38

39
drop table t1;
40
drop table t2;
41

42

43
###
44
# account test
45
##
46
create table t1(id int primary key, money1 int);
47
insert into t1(id,money1) values(1,100);
48
create table t2(id int primary key, money1 int);
49
insert into t2(id,money1) values(1,100);
50

51
select id,money1 from t1;
52
select id,money1 from t2;
53

54
--echo id1 - 100  id2 + 100
55
connection conn1;
56
begin;
57
update t1 set money1 = money1-100 where id = 1;
58
disconnect conn1;
59
--error 2006
60
update t2 set money1 = money1+100 where id = 1;
61
--error 2006
62
commit;
63
sleep 1;
64

65
connection conn2;
66
select id,money1 from t1;
67
select id,money1 from t2;
68

69
drop table t1;
70
drop table t2;
71