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

     1  set global enable_privilege_cache = off;
     2  create database sys_db_1;
     3  use sys_db_1;
     4  create table sys_tbl_1(a int primary key );
     5  insert into sys_tbl_1 values(1),(2),(3);
     6  create publication sys_pub_1 database sys_db_1;
     7  set global syspublications = "sys_pub_1";
     8  create account acc_idx ADMIN_NAME 'root' IDENTIFIED BY '123456';
     9  show subscriptions;
    10  pub_name    pub_account    pub_database    pub_time    sub_name    sub_time
    11  sys_pub_1    sys    sys_db_1    2024-01-05 18:12:37    sys_pub_1    2024-01-05 18:12:38
    12  set global syspublications = default;
    13  drop account acc_idx;
    14  drop publication sys_pub_1;
    15  drop database sys_db_1;
    16  create account acc_idx ADMIN_NAME 'root' IDENTIFIED BY '123456';
    17  create database db7;
    18  create publication pubname7 database db7 account acc_idx;
    19  internal error: database 'db7' does not exist
    20  drop account acc_idx;
    21  set global enable_privilege_cache = on;