oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
#owner: link.zt
5
#owner group: sql1
6
# tags: optimizer, outline
7

8
--disable_warnings
9
drop table if exists test;
10
--enable_warnings
11
create table test(a int,b int primary key);
12
insert into test values(1,1);
13
insert into test values(1,2);
14
insert into test values(1,3);
15
insert into test values(1,4);
16
select * from test;
17
--replace_regex /Plan signature: [0-9]*/Plan signature/
18
--disable_result_log
19
explain select * from test;
20
desc select * from test;
21
describe select * from test;
22
--enable_result_log
23
--replace_regex /Plan signature: [0-9]*/Plan signature/
24
--disable_result_log
25
explain insert into test values(1,5);
26
desc insert into test values(1,5);
27
describe insert into test values(1,5);
28
--enable_result_log
29
--replace_regex /Plan signature: [0-9]*/Plan signature/
30
--disable_result_log
31
explain insert into test values(1,4);
32
desc insert into test values(1,4);
33
describe insert into test values(1,4);
34
--enable_result_log
35
--replace_regex /Plan signature: [0-9]*/Plan signature/
36
--disable_result_log
37
explain update test set a=2 where b=2;
38
desc update test set a=2 where b=2;
39
describe update test set a=2 where b=2;
40
--enable_result_log
41
--replace_regex /Plan signature: [0-9]*/Plan signature/
42
--disable_result_log
43
explain update test set b=2 where a=1;
44
desc update test set b=2 where a=1;
45
describe update test set b=2 where a=1;
46
--enable_result_log
47
--replace_regex /Plan signature: [0-9]*/Plan signature/
48
--disable_result_log
49
explain delete from test where b=5;
50
desc delete from test where b=5;
51
describe delete from test where b=5;
52
--enable_result_log
53
--error 1064
54
explain create table test(a int,b int primary key);
55
--error 1064
56
desc create table test(a int,b int primary key);
57
--error 1064
58
describe create table test(a int,b int primary key);
59
--error 1064
60
explain drop table test;
61
--error 1064
62
desc drop table test;
63
--error 1064
64
describe drop table test;
65
--enable_result_log
66

67
--disable_warnings
68
drop table if exists sd;
69
--enable_warnings
70
create table sd(a int);
71
insert into sd values(5),(4),(4),(3),(2),(2),(2),(1);
72
--disable_result_log
73
explain select @rownum := @rownum + 1 as row, @rank := IF(@prev_score!=a, @rownum, @rank) as rank, @prev_score := a as score from sd;
74
--enable_result_log
75

76
## test for cast mod for explain: bug#8454097
77
explain outline select 1 < '2009-12-17 06:03:17';
78
drop table sd;
79