oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
set transaction_isolation='READ-COMMITTED';
4
set tx_isolation='READ-COMMITTED';
5
--enable_query_log
6
#owner: yuchen.wyc
7
#owner group: sql1
8

9
####test:two trx on one rows,one trx rollback
10
connect (conn0,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
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
--enable_sorted_result
14
--source mysql_test/include/index_quick_major.inc
15
--enable_sorted_result
16

17
connection conn0;
18
--disable_warnings
19
drop table if exists t1;
20
--enable_warnings
21
create table t1(pk int primary key, c1 int);
22
create index idx on t1(c1);
23
insert into t1 values(6,6),(7,7),(8,8);
24
--source mysql_test/include/check_all_idx_ok.inc
25

26
connection conn1;
27
set autocommit=0;
28

29
connection conn2;
30
set autocommit=0;
31

32
####insert +insert
33
connection conn1;
34
insert into t1 values(1,1);
35

36
connection conn2;
37
sleep 1;
38
send insert into t1 values(1,11);
39

40
connection conn1;
41
sleep 1;
42
commit;
43

44
connection conn2;
45
--error 1062
46
reap;
47
commit;
48
select * from t1;
49

50
####insert +replace
51
connection conn1;
52
insert into t1 values(2,2);
53

54
connection conn2;
55
sleep 1;
56
send replace into t1 values(2,12);
57

58
connection conn1;
59
sleep 1;
60
commit;
61

62
connection conn2;
63
reap;
64
commit;
65
select * from t1;
66

67
####replace +insert
68
connection conn1;
69
replace into t1 values(3,3);
70

71
connection conn2;
72
sleep 1;
73
send insert into t1 values(3,13);
74

75
connection conn1;
76
sleep 1;
77
commit;
78

79
connection conn2;
80
--error 1062
81
reap;
82
commit;
83
select * from t1;
84

85
####replace +replace
86
connection conn1;
87
replace into t1 values(4,4);
88

89
connection conn2;
90
sleep 1;
91
send replace into t1 values(4,14);
92

93
connection conn1;
94
sleep 1;
95
commit;
96

97
connection conn2;
98
reap;
99
commit;
100
select * from t1;
101

102
drop table t1;
103