github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/transaction/autocommit.result (about)

     1  set autocommit=1;
     2  drop table if exists t1;
     3  create table t1(a int);
     4  start transaction;
     5  insert into t1 values(1);
     6  start transaction;
     7  select * from t1;
     8  a
     9  1
    10  insert into t1 values(2);
    11  select * from t1;
    12  a
    13  2
    14  1
    15  rollback;
    16  select * from t1;
    17  a
    18  1
    19  start transaction;
    20  create table t2(a int);
    21  insert into t2 values (1);
    22  rollback;
    23  select * from t2;
    24  SQL parser error: table "t2" does not exist
    25  start transaction;
    26  use autocommit;
    27  start transaction;
    28  drop table t1;
    29  internal error: Only CREATE of DDL is supported in transactions
    30  commit;
    31  start transaction;
    32  set autocommit=1;
    33  internal error: Uncommitted transaction exists. Please commit or rollback first.
    34  commit;
    35  start transaction;
    36  show tables;
    37  tables_in_autocommit
    38  t1
    39  commit;
    40  set autocommit=0;
    41  drop table if exists t1;
    42  create table t1(a int);
    43  insert into t1 values(1);
    44  rollback;
    45  create table t1(a int);
    46  select * from t1;
    47  a
    48  insert into t1 values(1);
    49  insert into t1 values(2);
    50  set autocommit=1;
    51  internal error: Uncommitted transaction exists. Please commit or rollback first.
    52  commit;
    53  set autocommit=1;
    54  set autocommit=0;
    55  select * from t1;
    56  a
    57  1
    58  2
    59  insert into t1 values(3);
    60  create table t2 (a int);
    61  rollback;
    62  select * from t2;
    63  SQL parser error: table "t2" does not exist
    64  Previous DML conflicts with existing constraints or data format. This transaction has to be aborted
    65  insert into t1 values(3);
    66  use autocommit;
    67  show tables;
    68  tables_in_autocommit
    69  t1
    70  commit;
    71  set autocommit = 1;