github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/dml/checkpoint/checkpoint.test (about)

     1  drop database if exists db1;
     2  
     3  create database db1;
     4  use db1;
     5  drop table if exists t;
     6  create table t (a int);
     7  insert into t values (1), (2), (3), (4), (5);
     8  -- @separator:table
     9  -- @bvt:issue#9578
    10  select mo_ctl('dn','checkpoint','');
    11  -- @bvt:issue
    12  select * from t;
    13  delete from t where a in (1, 2, 3);
    14  -- @separator:table
    15  -- @bvt:issue#9578
    16  select mo_ctl('dn','checkpoint','');
    17  -- @bvt:issue
    18  select * from t;
    19  
    20  
    21  drop table if exists t;
    22  create table t (a int);
    23  insert into t values (1), (2), (3), (4), (5);
    24  delete from t where a = 2;
    25  insert into t values (6);
    26  delete from t where a = 3;
    27  -- @separator:table
    28  select mo_ctl('dn','checkpoint','');
    29  select * from t;
    30  
    31  drop table if exists t;
    32  create table t (a int);
    33  insert into t values (1), (2), (3), (4), (5);
    34  -- @separator:table
    35  select mo_ctl('dn','checkpoint','');
    36  -- @separator:table
    37  select mo_ctl('dn','checkpoint','');
    38  select * from t;
    39  
    40  drop database if exists db1;