oceanbase

1
# owner: peihan.dph
2
# owner group: sql2
3
# tags: optimizer
4

5
--result_format 4
6
--explain_protocol 0
7
connect (syscon, $OBMYSQL_MS0,admin,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
8

9
sleep 2;
10

11
connection default;
12

13
--disable_warnings
14
drop table if exists t1;
15
drop table if exists t2;
16
--enable_warnings
17

18
create table t1(c1 int,c2 int,c3 int);
19
create table t2(c1 int,c2 int,c3 int);
20

21
insert into t1 values(1,2,3);
22
insert into t1 values(1,2,3);
23
insert into t1 values(0,2,3);
24
insert into t1 values(2,2,3);
25
insert into t1 values(3,2,3);
26

27
insert into t2 values(2,2,3);
28
insert into t2 values(2,2,3);
29
insert into t2 values(0,2,3);
30
insert into t2 values(1,2,3);
31
insert into t2 values(null,2,3);
32
commit;
33

34
connection syscon;
35
sleep 2;
36

37
--explain_protocol 2
38
connection default;
39
set @@ob_enable_plan_cache = 0;
40
#set  @@ob_enable_trace_log=1;
41
#set  @@ob_log_level='trace';
42
explain select * from t1,t2;
43
select * from t1,t2;
44

45
connection syscon;
46
sleep 2;
47
--sleep 2
48