github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/table/truncate_table_4.sql (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  begin;
     6  truncate t1;
     7  truncate t1;
     8  truncate t1;
     9  truncate t1;
    10  truncate t1;
    11  truncate t1;
    12  show tables;
    13  commit;
    14  show tables;
    15  select count(*) from t1;
    16  -----------------------
    17  drop table if exists t1;
    18  begin;
    19  create table t1(a int);
    20  drop table t1;
    21  create table t1(a int);
    22  drop table t1;
    23  create table t1(a int);
    24  drop table t1;
    25  create table t1(a int);
    26  drop table t1;
    27  commit;
    28  show tables;
    29  -----------------------
    30  drop table if exists t1;
    31  begin;
    32  create table t1(a int);
    33  create table t2(a int);
    34  create table t3(a int);
    35  create table t4(a int);
    36  drop table t1;
    37  drop table t2;
    38  drop table t3;
    39  drop table t4;
    40  commit;
    41  show tables;