oceanbase

1

2
# owner: yuchen.wyc
3
# owner group: SQL1
4
# tags: optimizer
5

6
connect (conn1,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
7
connect (conn2,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
8

9
###
10
# root job need start participant
11
###
12
connection conn1;
13
--disable_warnings
14
drop table if exists t_single, t_part;
15
--enable_warnings
16
create table t_single (pk int primary key, c1 int);
17
create table t_part (pk int primary key, c1 int) partition by hash(pk) partitions 2;
18
insert into t_single values (1, 20), (2, 20);
19
insert into t_part values (1, 2), (2, 2);
20
begin;
21
select * from t_single for update;
22

23
connection conn2;
24
sleep 4;
25
#本机不一定有副本，所以形状可能会变，所以不能explain，所以这里只有一定的概率拦住不调start_participant的错误
26
#explain basic select /*+INDEX(INFO PRIMARY) READ_CONSISTENCY(WEAK) */ * from t_single t1 join t_part t2 on t1.pk = t2.c1;
27
select /*+INDEX(INFO PRIMARY) READ_CONSISTENCY(WEAK) */ * from t_single t1 join t_part t2 on t1.pk = t2.c1 order by t2.pk;
28

29
connection conn1;
30
rollback;
31

32
drop table t_single, t_part;
33

34