github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/pessimistic_transaction/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  Duplicate entry '1' for key 'a'
    16  select * from t1;
    17  a
    18  1
    19  insert into t1 values(2);
    20  insert into t1 values(2);
    21  Duplicate entry '2' for key 'a'
    22  select * from t1;
    23  a
    24  1
    25  2
    26  insert into t1 values(3);
    27  delete from t1 where a = 3;
    28  delete from t1 where b = 3;
    29  invalid input: column b does not exist
    30  insert into t1 values(3);
    31  update t1 set a = 2;
    32  Duplicate entry '2' for key 'a'
    33  commit ;
    34  select * from t1;
    35  a
    36  1
    37  2
    38  3
    39  create table if not exists t2( id int primary key );
    40  insert into t2 values(1);
    41  select * from t2;
    42  id
    43  1
    44  set autocommit = 1;
    45  begin;
    46  insert into t2 values(2);
    47  select * from t2;
    48  id
    49  2
    50  1
    51  insert into t2 values(1);
    52  Duplicate entry '1' for key 'id'
    53  select * from t2;
    54  id
    55  2
    56  1
    57  commit;
    58  select * from t2;
    59  id
    60  1
    61  2
    62  drop table t1;
    63  drop table t2;
    64  drop database if exists rollbacktest;