github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/optimistic/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  select * from t1;
     8  a
     9  1
    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  begin;
    48  insert into t2 values(2);
    49  select * from t2;
    50  id
    51  2
    52  1
    53  insert into t2 values(1);
    54  select * from t2;
    55  id
    56  2
    57  1
    58  1
    59  commit;
    60  Duplicate entry '1' for key 'id'
    61  select * from t2;
    62  id
    63  1
    64  drop table t1;
    65  drop table t2;
    66  drop database if exists rollbacktest;
    67  set @@autocommit = 1;