github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/transaction/atomicity.result (about)

     1  drop table if exists test_11;
     2  create table test_11 (c int primary key,d int);
     3  begin;
     4  Insert into test_11 values(1,1);
     5  Insert into test_11 values(2,2);
     6  Rollback;
     7  select * from test_11 ;
     8  c    d
     9  begin;
    10  Insert into test_11 values(1,1);
    11  Insert into test_11 values(2,2);
    12  commit;
    13  select * from test_11 ;
    14  c    d
    15  1    1
    16  2    2
    17  drop table if exists test_11;
    18  create table test_11 (c int primary key,d int);
    19  Insert into test_11 values(1,1);
    20  Insert into test_11 values(2,2);
    21  Insert into test_11 values(3,1);
    22  Insert into test_11 values(4,2);
    23  begin;
    24  delete from test_11 where c < 3;
    25  update test_11 set d = c + 1 where c >= 3;
    26  rollback;
    27  select * from test_11 ;
    28  c    d
    29  1    1
    30  2    2
    31  3    1
    32  4    2
    33  begin;
    34  delete from test_11 where c <3;
    35  update test_11 set d = c + 1 where c >= 3;
    36  commit;
    37  select * from test_11 ;
    38  c    d
    39  3    4
    40  4    5
    41  drop table if exists test_11;
    42  begin;
    43  create table test_11 (c int primary key,d int);
    44  Insert into test_11 values(1,1);
    45  Insert into test_11 values(2,2);
    46  Insert into test_11 values(3,1);
    47  Insert into test_11 values(4,2);
    48  rollback;
    49  select * from test_11 ;
    50  SQL parser error: table "test_11" does not exist
    51  begin;
    52  create table test_11 (c int primary key,d int);
    53  Insert into test_11 values(1,1);
    54  Insert into test_11 values(2,2);
    55  Insert into test_11 values(3,1);
    56  Insert into test_11 values(4,2);
    57  delete from test_11 where c <3;
    58  update test_11 set d = c + 1 where c >= 3;
    59  commit;
    60  select * from test_11;
    61  c    d
    62  3    4
    63  4    5
    64  drop table if exists test_11;
    65  create table test_11 (c int primary key,d int);
    66  Insert into test_11 values(1,1);
    67  Insert into test_11 values(2,2);
    68  begin;
    69  Insert into test_11 values(3,1);
    70  Insert into test_11 values(4,2);
    71  rollback;
    72  select * from test_11;
    73  c    d
    74  1    1
    75  2    2
    76  drop table if exists test_11;
    77  create table test_11 (c int primary key,d int);
    78  Insert into test_11 values(1,1);
    79  Insert into test_11 values(2,2);
    80  begin;
    81  Insert into test_11 values(3,1);
    82  Insert into test_11 values(4,2);
    83  commit;
    84  drop table if exists test_11;
    85  select * from test_11 ;
    86  SQL parser error: table "test_11" does not exist