oceanbase

1
#owner: bowen.gbw
2
#group: storage
3

4
--disable_warnings
5
drop table if exists msdt1;
6
drop table if exists msdt2;
7
--enable_warnings
8

9
create table msdt1(a int, b int);
10
insert into msdt1 values(1, 1), (2, 2);
11

12
alter table msdt1 add x varchar(10) after a;
13
insert into msdt1 values(3, 'hehe', 3);
14

15
create table msdt2(a int, b int);
16

17
# msdt1
18
let $tenant_id1 = query_get_value(select tenant_id from oceanbase.__all_virtual_table where table_name = 'msdt1', tenant_id, 1);
19
let $tablet_id1 = query_get_value(select tablet_id from oceanbase.__all_virtual_table where table_name = 'msdt1', tablet_id, 1);
20
let $ls_id1 = query_get_value(select ls_id from oceanbase.DBA_OB_TABLET_TO_LS where tablet_id = $tablet_id1, ls_id, 1);
21

22
let $report_cnt1 = query_get_value(select count(*) as cnt from oceanbase.__all_virtual_tablet_meta_table where tenant_id = $tenant_id1 and ls_id = $ls_id1 and tablet_id = $tablet_id1, cnt, 1);
23
let $unit_cnt1 = query_get_value(select count(*) as cnt from oceanbase.__all_virtual_unit where tenant_id = $tenant_id1, cnt, 1);
24

25
--disable_query_log
26
eval select $report_cnt1 = $unit_cnt1 as result;
27
--enable_query_log
28

29
# msdt2
30
let $tenant_id2 = query_get_value(select tenant_id from oceanbase.__all_virtual_table where table_name = 'msdt2', tenant_id, 1);
31
let $tablet_id2 = query_get_value(select tablet_id from oceanbase.__all_virtual_table where table_name = 'msdt2', tablet_id, 1);
32
let $ls_id2 = query_get_value(select ls_id from oceanbase.DBA_OB_TABLET_TO_LS where tablet_id = $tablet_id2, ls_id, 1);
33

34
let $report_cnt2 = query_get_value(select count(*) as cnt from oceanbase.__all_virtual_tablet_meta_table where tenant_id = $tenant_id2 and ls_id = $ls_id2 and tablet_id = $tablet_id2, cnt, 1);
35
let $unit_cnt2 = query_get_value(select count(*) as cnt from oceanbase.__all_virtual_unit where tenant_id = $tenant_id2, cnt, 1);
36

37
--disable_query_log
38
eval select $report_cnt2 = $unit_cnt2 as result;
39
--enable_query_log
40

41
drop table msdt1;
42
drop table msdt2;