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

     1  drop database if exists rollbacktest;
     2  create database rollbacktest;
     3  set @@autocommit = 0;
     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  begin;
    45  insert into t2 values(2);
    46  select * from t2;
    47  id
    48  2
    49  1
    50  insert into t2 values(1);
    51  Duplicate entry '1' for key 'id'
    52  select * from t2;
    53  id
    54  2
    55  1
    56  commit;
    57  select * from t2;
    58  id
    59  1
    60  2
    61  drop table t1;
    62  drop table t2;
    63  drop database if exists rollbacktest;
    64  set @@autocommit = 1;