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