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

     1  -- Test explicit transactions are nested, Uncommitted content is forced to be submitted
     2  drop table if exists t5;
     3  start transaction;
     4  
     5  create table t5(a int);
     6  insert into t5 values(10),(20),(30);
     7  -- execute success
     8  drop table t5;
     9  
    10  start transaction;
    11  show tables;
    12  -- t5 is dropped. error and rollback.
    13  insert into t5 values(100),(2000),(3000);
    14  
    15  rollback;
    16  set @@autocommit=on;
    17  
    18  --env prepare statement
    19  drop table if exists t5;
    20  drop table if exists dis_table_02;
    21  drop table if exists dis_table_03;
    22  
    23  -- @bvt:issue#14633
    24  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) );
    25  insert into dis_table_02(b,c) values ('aaaa','2020-09-08');
    26  insert into dis_table_02(b,c) values ('aaaa','2020-09-08');
    27  create table dis_table_03(b varchar(25) primary key,c datetime);
    28  begin ;
    29  insert into dis_table_03 select b,c from dis_table_02;
    30  select * from dis_table_03;
    31  -- @session:id=1{
    32  use drop_table_truncate;
    33  select * from dis_table_03;
    34  truncate table dis_table_03;
    35  -- @session}
    36  insert into dis_table_03 select 'bbb','2012-09-30';
    37  select * from dis_table_03;
    38  commit;
    39  
    40  drop table if exists dis_table_02;
    41  drop table if exists dis_table_03;
    42  
    43  begin;
    44  create table t1(a int);
    45  show tables;
    46  insert into t1 values (1);
    47  drop table t1;
    48  show tables;
    49  commit;
    50  
    51  create table t1(a int);
    52  begin;
    53  insert into t1 values (1);
    54  select * from t1;
    55  -- @session:id=1{
    56  use drop_table_truncate;
    57  -- @wait:0:commit
    58  truncate table t1;
    59  select * from t1;
    60  -- @session}
    61  select * from t1;
    62  commit;
    63  select * from t1;
    64  
    65  begin;
    66  create table t2(a int);
    67  show tables;
    68  insert into t2 values (1);
    69  truncate table t2;
    70  insert into t2 values (2);
    71  select * from t2;
    72  drop table t2;
    73  show tables;
    74  commit;
    75  -- @bvt:issue