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
# bad case
18
##
19
create table t1(id int primary key, money1 int);
20

21
insert into t1 values(1,100);
22

23
## setup session timeout parameters
24
--disable_query_log
25
connection conn1;
26
set session ob_query_timeout = 2000000; #-- 2s
27
set session ob_trx_timeout = 20000000; #-- 20s
28
set session ob_trx_idle_timeout = 10000000; #-- 10s
29
connection conn2;
30
set session ob_query_timeout = 2000000; #-- 2s
31
set session ob_trx_timeout = 20000000; #-- 20s
32
set session ob_trx_idle_timeout = 10000000; #-- 10s
33
connection conn3;
34
set session ob_query_timeout = 2000000; #-- 2s
35
set session ob_trx_timeout = 20000000; #-- 20s
36
set session ob_trx_idle_timeout = 10000000; #-- 10s
37
connection conn4;
38
set session ob_query_timeout = 2000000; #-- 2s
39
set session ob_trx_timeout = 20000000; #-- 20s
40
set session ob_trx_idle_timeout = 10000000; #-- 10s
41
--enable_query_log
42

43
connection conn1;
44
begin;
45
update t1 set money1 = money1+100 where id=2;
46

47
connection conn2;
48
begin;
49
insert into t1 values(2,100);
50

51
connection conn1;
52
commit;
53
connection conn2;
54
ROLLBACK;
55

56
select * from t1;
57

58

59
connection conn1;
60
begin;
61
insert into t1 values(3,100);
62
commit;
63

64
connection conn2;
65
begin;
66
update t1 set money1 = money1+100 where id=3;
67

68
connection conn3;
69
set @@ob_trx_timeout=100000000;
70
begin;
71
set @@ob_query_timeout = 10000000;
72
--error 1205, 4012
73
delete from t1 where id = 3;
74

75
connection conn2;
76
commit;
77
connection conn3;
78
ROLLBACK;
79

80
select * from t1;
81
drop table t1;
82