github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/tenant/pub_sub1.result (about)

     1  set global enable_privilege_cache = off;
     2  create database db1;
     3  create publication pubname1 database db1 account test_tenant_1 comment 'publish db1 database';
     4  create publication pubname2 database db1 account test_tenant_1 comment 'publish db1 database';
     5  set global syspublications = "pubname1,pubname2";
     6  create account test_tenant_2 admin_name 'test_account' identified by '111';
     7  show subscriptions;
     8  pub_name    pub_account    pub_database    pub_time    sub_name    sub_time
     9  show databases;
    10  Database
    11  mo_catalog
    12  system
    13  system_metrics
    14  information_schema
    15  mysql
    16  set global syspublications = default;
    17  drop account test_tenant_2;
    18  drop publication pubname1;
    19  drop publication pubname2;
    20  drop database db1;
    21  set global enable_privilege_cache = on;
    22  create account `0b6d35cc_11ab_4da5_a5c5_c4cc09917c11` admin_name 'admin' identified by '111';
    23  create account `62915dd9_d454_4b02_be16_0741d94b62cc` admin_name 'admin' identified by '111';
    24  create database test;
    25  use test;
    26  create table tt(a int);
    27  insert into tt values(1);
    28  create publication mo_test_pub database test account `62915dd9_d454_4b02_be16_0741d94b62cc`;
    29  create database mo_test_sub from `0b6d35cc_11ab_4da5_a5c5_c4cc09917c11` publication mo_test_pub;
    30  show subscriptions;
    31  pub_name    pub_account    pub_database    pub_time    sub_name    sub_time
    32  mo_test_pub    0b6d35cc_11ab_4da5_a5c5_c4cc09917c11    test    2024-01-05 18:13:15    mo_test_sub    2024-01-05 18:13:15
    33  drop publication mo_test_pub;
    34  drop account `0b6d35cc_11ab_4da5_a5c5_c4cc09917c11`;
    35  drop account `62915dd9_d454_4b02_be16_0741d94b62cc`;