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

     1  drop table if exists t1;
     2  create table t1(a int);
     3  show tables;
     4  Tables_in_drop_table2
     5  t1
     6  begin;
     7  show tables;
     8  Tables_in_drop_table2
     9  t1
    10  show columns from t1;
    11  Field    Type    Null    Key    Default    Extra    Comment
    12  a    INT(32)    YES        null        
    13  drop table t1;
    14  show tables;
    15  Tables_in_drop_table2
    16  create table t1(a int,b int);
    17  show tables;
    18  Tables_in_drop_table2
    19  t1
    20  show columns from t1;
    21  Field    Type    Null    Key    Default    Extra    Comment
    22  a    INT(32)    YES        null        
    23  b    INT(32)    YES        null        
    24  create table t2(a int);
    25  show tables;
    26  Tables_in_drop_table2
    27  t1
    28  t2
    29  show columns from t2;
    30  Field    Type    Null    Key    Default    Extra    Comment
    31  a    INT(32)    YES        null        
    32  rollback;
    33  show tables;
    34  Tables_in_drop_table2
    35  t1
    36  show columns from t1;
    37  Field    Type    Null    Key    Default    Extra    Comment
    38  a    INT(32)    YES        null        
    39  begin;
    40  show tables;
    41  Tables_in_drop_table2
    42  t1
    43  show columns from t1;
    44  Field    Type    Null    Key    Default    Extra    Comment
    45  a    INT(32)    YES        null        
    46  drop table t1;
    47  show tables;
    48  Tables_in_drop_table2
    49  create table t1(a int, b int);
    50  show tables;
    51  Tables_in_drop_table2
    52  t1
    53  show columns from t1;
    54  Field    Type    Null    Key    Default    Extra    Comment
    55  a    INT(32)    YES        null        
    56  b    INT(32)    YES        null        
    57  create table t2(a int);
    58  show tables;
    59  Tables_in_drop_table2
    60  t1
    61  t2
    62  commit;
    63  show tables;
    64  Tables_in_drop_table2
    65  t1
    66  t2
    67  drop table if exists t1;
    68  drop table if exists t2;