github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/optimistic/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  select * from t1;
     8  a
     9  1
    10  1
    11  delete from t1 where a = 1;
    12  insert into t1 values(1);
    13  insert into t1 values(1);
    14  select * from t1;
    15  a
    16  1
    17  1
    18  insert into t1 values(2);
    19  insert into t1 values(2);
    20  select * from t1;
    21  a
    22  1
    23  1
    24  2
    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  1
    38  2
    39  2
    40  3
    41  create table if not exists t2( id int primary key );
    42  insert into t2 values(1);
    43  select * from t2;
    44  id
    45  1
    46  insert into t2 values(2);
    47  select * from t2;
    48  id
    49  1
    50  2
    51  insert into t2 values(1);
    52  select * from t2;
    53  id
    54  1
    55  2
    56  1
    57  commit;
    58  select * from t2;
    59  id
    60  1
    61  2
    62  1
    63  commit;
    64  drop table t1;
    65  drop table t2;
    66  drop database if exists rollbacktest;
    67  set @@autocommit = 1;