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

     1  drop account if exists test_tenant_1;
     2  create account test_tenant_1 admin_name 'test_account' identified by '111';
     3  drop database if exists republication01;
     4  create database republication01;
     5  use republication01;
     6  create publication publication01 database republication01 account test_tenant_1 comment 'republish';
     7  create table repub01(col1 int);
     8  insert into repub01 values (1);
     9  drop database if exists resub01;
    10  create database resub01 from sys publication publication01;
    11  show subscriptions all;
    12  pub_name    pub_account    pub_database    pub_time    sub_name    sub_time
    13  publication01    sys    republication01    2024-05-09 13:58:08    resub01    2024-05-09 13:58:08
    14  drop database if exists database03;
    15  create database database03;
    16  use database03;
    17  create table table01 (col1 int);
    18  insert into table01 values (1);
    19  insert into table01 select * from table01;
    20  alter publication publication01 database database03;
    21  show publications;
    22  publication    database    create_time    update_time    sub_account    comments
    23  publication01    database03    2024-05-09 13:58:08    2024-05-09 13:58:08    test_tenant_1    republish
    24  use resub01;
    25  show tables;
    26  Tables_in_resub01
    27  table01
    28  select * from table01;
    29  col1
    30  1
    31  1
    32  show columns from table01;
    33  Field    Type    Null    Key    Default    Extra    Comment
    34  col1    INT(32)    YES        null
    35  desc table01;
    36  Field    Type    Null    Key    Default    Extra    Comment
    37  col1    INT(32)    YES        null
    38  show table status;
    39  Name    Engine    Row_format    Rows    Avg_row_length    Data_length    Max_data_length    Index_length    Data_free    Auto_increment    Create_time    Update_time    Check_time    Collation    Checksum    Create_options    Comment    Role_id    Role_name
    40  table01    Tae    Dynamic    2    0    72    0    0    NULL    0    2024-05-09 13:58:08    NULL    NULL    utf-8    NULL            0    moadmin
    41  alter publication publication01 database republication01;
    42  show publications;
    43  publication    database    create_time    update_time    sub_account    comments
    44  publication01    republication01    2024-05-09 13:58:08    2024-05-09 13:58:08    test_tenant_1    republish
    45  show subscriptions all;
    46  pub_name    pub_account    pub_database    pub_time    sub_name    sub_time
    47  publication01    sys    republication01    2024-05-09 13:58:08    resub01    2024-05-09 13:58:08
    48  use resub01;
    49  show tables;
    50  Tables_in_resub01
    51  repub01
    52  show columns from repub01;
    53  Field    Type    Null    Key    Default    Extra    Comment
    54  col1    INT(32)    YES        null
    55  desc repub01;
    56  Field    Type    Null    Key    Default    Extra    Comment
    57  col1    INT(32)    YES        null
    58  select * from repub01;
    59  col1
    60  1
    61  drop publication publication01;
    62  drop database database03;
    63  drop database republication01;
    64  drop account test_tenant_1;