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

     1  drop table if exists t1;
     2  create table t1(a int);
     3  insert into t1 values(1),(2),(3),(4);
     4  select count(*) from t1;
     5  count(*)
     6  4
     7  begin;
     8  truncate t1;
     9  truncate t1;
    10  truncate t1;
    11  truncate t1;
    12  truncate t1;
    13  truncate t1;
    14  show tables;
    15  Tables_in_truncate_table_4
    16  t1
    17  commit;
    18  show tables;
    19  Tables_in_truncate_table_4
    20  t1
    21  select count(*) from t1;
    22  count(*)
    23  0
    24  drop table if exists t1;
    25  begin;
    26  create table t1(a int);
    27  drop table t1;
    28  create table t1(a int);
    29  drop table t1;
    30  create table t1(a int);
    31  drop table t1;
    32  create table t1(a int);
    33  drop table t1;
    34  commit;
    35  show tables;
    36  Tables_in_truncate_table_4
    37  drop table if exists t1;
    38  begin;
    39  create table t1(a int);
    40  create table t2(a int);
    41  create table t3(a int);
    42  create table t4(a int);
    43  drop table t1;
    44  drop table t2;
    45  drop table t3;
    46  drop table t4;
    47  commit;
    48  show tables;
    49  Tables_in_truncate_table_4