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

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