github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/tenant/init_pub.sql (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  -- @session:id=1&user=acc_idx:root&password=123456
    10  -- @ignore:3,5
    11  show subscriptions;
    12  -- @session
    13  set global syspublications = default;
    14  drop account acc_idx;
    15  drop publication sys_pub_1;
    16  drop database sys_db_1;
    17  
    18  create account acc_idx ADMIN_NAME 'root' IDENTIFIED BY '123456';
    19  -- @session:id=2&user=acc_idx:root&password=123456
    20  create database db7;
    21  -- @session
    22  create publication pubname7 database db7 account acc_idx;
    23  drop account acc_idx;
    24  set global enable_privilege_cache = on;