oceanbase

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

4
--disable_warnings
5
drop table if exists msdt_lob;
6
drop table if exists msdt_normal;
7
--enable_warnings
8

9
create table msdt_lob(c1 text, c2 int);
10

11
alter table msdt_lob drop c2;
12

13
create table msdt_normal(a int, b int);
14

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

20
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);
21
let $unit_cnt1 = query_get_value(select count(*) as cnt from oceanbase.__all_virtual_unit where tenant_id = $tenant_id1, cnt, 1);
22

23
--disable_query_log
24

25
let $__i__= 120;
26
while($__i__ > 0)
27
{
28
    sleep 1;
29
    dec $__i__;
30
    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);
31
    if($report_cnt1 == $unit_cnt1)
32
    {
33
      let $__i__ = -1;
34
    }
35
}
36

37

38
eval select $report_cnt1 = $unit_cnt1 as result;
39
--enable_query_log
40

41
# msdt_normal
42
let $tenant_id2 = query_get_value(select tenant_id from oceanbase.__all_virtual_table where table_name = 'msdt_normal', tenant_id, 1);
43
let $tablet_id2 = query_get_value(select tablet_id from oceanbase.__all_virtual_table where table_name = 'msdt_normal', tablet_id, 1);
44
let $ls_id2 = query_get_value(select ls_id from oceanbase.DBA_OB_TABLET_TO_LS where tablet_id = $tablet_id2, ls_id, 1);
45

46
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);
47
let $unit_cnt2 = query_get_value(select count(*) as cnt from oceanbase.__all_virtual_unit where tenant_id = $tenant_id2, cnt, 1);
48

49
--disable_query_log
50
eval select $report_cnt2 = $unit_cnt2 as result;
51
--enable_query_log
52

53
drop table msdt_lob;
54
drop table msdt_normal;
55