oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
# owner: bin.lb
5
# owner group: SQL2
6
# tags: dml
7
# description:
8
#
9
#alter system set balance_worker_idle_sleep_seconds=33 COMMENT 'new all balance_worker_idle_sleep_seconds' SERVer_TYPE = ROOTSERVER cluster = 0;
10

11
#alter system set balance_worker_idle_sleep_seconds=39 COMMENT 'new1 root balance_worker_idle_sleep_seconds' SERVer_TYPE = ROOTSERVER server_ip = '127.0.0.1' server_port = 47051;
12

13
create table t_status(id int primary key, chunkserver char(90), mergesrver char(90), rootserver char(90), updateserver char(90), tablet_max_size int, status int);
14

15
insert into t_status(id, chunkserver, tablet_max_size, status) values(1, 'chunkserver', 1024, 0);
16

17
select id, chunkserver, status from t_status;
18

19
select id, chunkserver, status as verbose from t_status;
20

21
select id, chunkserver, grants.status as verbose from t_status grants;
22

23
--error 1064
24
select use_bloom_filter() from dual;
25

26
--error  1305
27
select use_bloom() from dual;
28

29
drop table t_status;
30

31