oceanbase

1
#--disable_query_log
2
#--disable_result_log
3
#
4
#let $index_status_expect = 2;
5
#let $result = 2;
6
#
7
#connect (obsys_caio,$OBMYSQL_MS0,admin,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
8
#connection obsys_caio;
9
#let $i=210;
10
#while($i>0)
11
#{
12
#    sleep 1;
13
#    #--echo $index_name
14
#    ##    let $result = query_get_value(select count(*) from oceanbase.__all_virtual_table where table_name like '__idx_%' and index_status!=2,count(*),1);
15
#    let $result = query_get_value(select count(*) from oceanbase.__all_virtual_table as t join oceanbase.__all_virtual_database as d where t.tenant_id = d.tenant_id and t.database_id = d.database_id and d.in_recyclebin = false and d.database_name != "__recyclebin" and t.table_name like '__idx_%' and t.index_status!=2,count(*),1);
16
#    if($result == 0)
17
#    {
18
#        let $i = -4;
19
#    }
20
#    dec $i;
21
#}
22
#sleep 2;
23
#if($i != -5)
24
#{
25
#    let $table_id = query_get_value(select table_id from oceanbase.__all_virtual_table as t join oceanbase.__all_virtual_database as d where t.tenant_id = d.tenant_id and t.database_id = d.database_id and d.in_recyclebin = false and d.database_name != "__recyclebin" and t.table_name like '__idx_%' and t.index_status!=2 limit 1,table_id,1);
26
#    --echo $result idx is build failed, first table id is $table_id
27
#}
28
#disconnect obsys_caio;
29
#connection default;
30
#--enable_query_log
31
#--enable_result_log
32