github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/pessimistic_transaction/flush.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', 'flush', 'db1.t');
     8  mo_ctl(dn, flush, db1.t)
     9  {\n  "method": "Flush",\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  begin;
    19  select mo_ctl('dn', 'flush', 'db1.t');
    20  mo_ctl(dn, flush, db1.t)
    21  {\n  "method": "Flush",\n  "result": [\n    {\n      "returnStr": "OK"\n    }\n  ]\n}\n
    22  select * from t;
    23  a
    24  4
    25  5
    26  commit;
    27  drop table if exists t;
    28  create table t (a int);
    29  insert into t values (1), (2), (3), (4), (5);
    30  delete from t where a = 2;
    31  insert into t values (6);
    32  delete from t where a = 3;
    33  begin;
    34  insert into db1.t values (100); -- this row is invisible for begin
    35  select mo_ctl('dn', 'flush', 'db1.t'); -- flush
    36  mo_ctl(dn, flush, db1.t)
    37  {\n  "method": "Flush",\n  "result": [\n    {\n      "returnStr": "OK"\n    }\n  ]\n}\n
    38  select a from db1.t where a = 1; -- pull
    39  a
    40  1
    41  select * from t;
    42  a
    43  1
    44  4
    45  5
    46  6
    47  100
    48  commit;
    49  drop table if exists t;
    50  create table t (a int);
    51  insert into t values (1), (2), (3);
    52  begin;
    53  select * from t;
    54  a
    55  1
    56  2
    57  3
    58  select mo_ctl('dn', 'flush', 'db1.t');
    59  mo_ctl(dn, flush, db1.t)
    60  {\n  "method": "Flush",\n  "result": [\n    {\n      "returnStr": "OK"\n    }\n  ]\n}\n
    61  select a from db1.t where a = 1;
    62  a
    63  1
    64  select * from t;
    65  a
    66  1
    67  2
    68  3
    69  commit;
    70  drop database if exists db1;