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

     1  drop database if exists rollbacktest;
     2  create database rollbacktest;
     3  set @@autocommit = 1;
     4  create table t1(a int primary key );
     5  insert into t1 values(1);
     6  insert into t1 values(1);
     7  Duplicate entry '1' for key 'a'
     8  select * from t1;
     9  a
    10  1
    11  begin;
    12  delete from t1 where a = 1;
    13  insert into t1 values(1);
    14  insert into t1 values(1);
    15  select * from t1;
    16  a
    17  1
    18  1
    19  insert into t1 values(2);
    20  insert into t1 values(2);
    21  select * from t1;
    22  a
    23  1
    24  1
    25  2
    26  2
    27  insert into t1 values(3);
    28  delete from t1 where a = 3;
    29  delete from t1 where b = 3;
    30  invalid input: column b does not exist
    31  insert into t1 values(3);
    32  update t1 set a = 2;
    33  Duplicate entry '2' for key 'a'
    34  commit ;
    35  select * from t1;
    36  a
    37  1
    38  1
    39  2
    40  2
    41  3
    42  create table if not exists t2( id int primary key );
    43  insert into t2 values(1);
    44  select * from t2;
    45  id
    46  1
    47  set autocommit = 1;
    48  begin;
    49  insert into t2 values(2);
    50  select * from t2;
    51  id
    52  2
    53  1
    54  insert into t2 values(1);
    55  select * from t2;
    56  id
    57  2
    58  1
    59  1
    60  commit;
    61  Duplicate entry '1' for key 'id'
    62  select * from t2;
    63  id
    64  1
    65  drop table t1;
    66  drop table t2;
    67  drop database if exists rollbacktest;