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

     1  drop table if exists t5;
     2  start transaction;
     3  create table t5(a int);
     4  insert into t5 values(10),(20),(30);
     5  drop table t5;
     6  start transaction;
     7  show tables;
     8  Tables_in_autocommit_1
     9  insert into t5 values(100),(2000),(3000);
    10  no such table drop_table_truncate.t5
    11  rollback;
    12  set @@autocommit=on;
    13  drop table if exists t5;
    14  drop table if exists dis_table_02;
    15  drop table if exists dis_table_03;
    16  create table dis_table_02(a int not null auto_increment,b varchar(25) not null,c datetime,primary key(a),key bstr (b),key cdate (c) );
    17  insert into dis_table_02(b,c) values ('aaaa','2020-09-08');
    18  insert into dis_table_02(b,c) values ('aaaa','2020-09-08');
    19  create table dis_table_03(b varchar(25) primary key,c datetime);
    20  begin ;
    21  insert into dis_table_03 select b,c from dis_table_02;
    22  Duplicate entry 'aaaa' for key 'b'
    23  select * from dis_table_03;
    24  b    c
    25  use drop_table_truncate;
    26  select * from dis_table_03;
    27  b    c
    28  truncate table dis_table_03;
    29  insert into dis_table_03 select 'bbb','2012-09-30';
    30  select * from dis_table_03;
    31  b    c
    32  bbb    2012-09-30 00:00:00
    33  commit;
    34  drop table if exists dis_table_02;
    35  drop table if exists dis_table_03;
    36  begin;
    37  create table t1(a int);
    38  show tables;
    39  Tables_in_drop_table_truncate
    40  t1
    41  insert into t1 values (1);
    42  drop table t1;
    43  show tables;
    44  Tables_in_drop_table_truncate
    45  commit;
    46  create table t1(a int);
    47  begin;
    48  insert into t1 values (1);
    49  select * from t1;
    50  a
    51  1
    52  use drop_table_truncate;
    53  truncate table t1;
    54  select * from t1;
    55  a
    56  select * from t1;
    57  a
    58  commit;
    59  select * from t1;
    60  a
    61  begin;
    62  create table t2(a int);
    63  show tables;
    64  Tables_in_drop_table_truncate
    65  t2
    66  t1
    67  insert into t2 values (1);
    68  truncate table t2;
    69  insert into t2 values (2);
    70  select * from t2;
    71  a
    72  2
    73  drop table t2;
    74  show tables;
    75  Tables_in_drop_table_truncate
    76  t1
    77  commit;