oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4

5
#owner: linlin.xll
6
#owner group: SQL1
7
#description:
8
#tags: dml, trx
9

10
#show variables like 'ob_query_timeout';
11

12
--disable_warnings
13
drop table if exists t1;
14
--enable_warnings
15

16
create table t1(pk int primary key, c1 int);
17
insert into t1 values(1,1);
18

19
connect (conn1,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
20
connect (conn2,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
21

22

23
connection conn1;
24
begin;
25
select *  from t1   where pk=1 for update;
26
update t1 set c1=c1+1 where pk=1;
27

28

29
connection conn2;
30
begin;
31
send select *  from t1  where t1.pk=1 for update;
32
--real_sleep 2
33

34
connection conn1;
35
commit;
36

37
connection conn2;
38
reap;
39
update t1 set c1=c1+1 where pk=1;
40
commit;
41

42

43
select * from t1;
44

45

46

47

48