otimestamp_import_time_zone_mysql.inc 930 字节
Newer Older
W
wangzelin.wzl 已提交
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

#--echo
#--echo ########### import time zone info ###########

--disable_query_log
--disable_result_log
--disable_warnings

connect (conn_admin_tz, $OBMYSQL_MS0,admin,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
connection conn_admin_tz;
select count(*) c1 from oceanbase.__all_tenant_time_zone;
select count(*) c1 from oceanbase.__all_tenant_time_zone_name;
select count(*) c1 from oceanbase.__all_tenant_time_zone_transition;
select count(*) c1 from oceanbase.__all_tenant_time_zone_transition_type;
delete from oceanbase.__all_tenant_time_zone;
delete from oceanbase.__all_tenant_time_zone_name;
delete from oceanbase.__all_tenant_time_zone_transition;
delete from oceanbase.__all_tenant_time_zone_transition_type;
alter system change tenant mysql ;
sleep 2;

--source mysql_test/test_suite/time_zone/t/time_zone_info.sql

sleep 10;
disconnect conn_admin_tz;
connection default;

--enable_query_log
--enable_result_log
--enable_warnings