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

     1  drop database if exists db1;
     2  create database db1;
     3  use db1;
     4  drop table if exists t;
     5  create table t (a int);
     6  insert into t values (1), (2), (3), (4), (5);
     7  select mo_ctl('dn','checkpoint','');
     8  mo_ctl(dn, checkpoint, )
     9  {\n  "method": "Checkpoint",\n  "result": [\n    {\n      "returnStr": "OK"\n    }\n  ]\n}\n
    10  select * from t;
    11  a
    12  1
    13  2
    14  3
    15  4
    16  5
    17  delete from t where a in (1, 2, 3);
    18  select mo_ctl('dn','checkpoint','');
    19  mo_ctl(dn, checkpoint, )
    20  {\n  "method": "Checkpoint",\n  "result": [\n    {\n      "returnStr": "OK"\n    }\n  ]\n}\n
    21  select * from t;
    22  a
    23  4
    24  5
    25  drop table if exists t;
    26  create table t (a int);
    27  insert into t values (1), (2), (3), (4), (5);
    28  delete from t where a = 2;
    29  insert into t values (6);
    30  delete from t where a = 3;
    31  select mo_ctl('dn','checkpoint','');
    32  mo_ctl(dn, checkpoint, )
    33  {\n  "method": "Checkpoint",\n  "result": [\n    {\n      "returnStr": "OK"\n    }\n  ]\n}\n
    34  select * from t;
    35  a
    36  1
    37  4
    38  5
    39  6
    40  drop table if exists t;
    41  create table t (a int);
    42  insert into t values (1), (2), (3), (4), (5);
    43  select mo_ctl('dn','checkpoint','');
    44  mo_ctl(dn, checkpoint, )
    45  {\n  "method": "Checkpoint",\n  "result": [\n    {\n      "returnStr": "OK"\n    }\n  ]\n}\n
    46  select mo_ctl('dn','checkpoint','');
    47  mo_ctl(dn, checkpoint, )
    48  {\n  "method": "Checkpoint",\n  "result": [\n    {\n      "returnStr": "OK"\n    }\n  ]\n}\n
    49  select * from t;
    50  a
    51  1
    52  2
    53  3
    54  4
    55  5
    56  drop database if exists db1;