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

     1  drop database if exists special;
     2  create database special;
     3  use special;
     4  create table ct_07(a int,b varchar(25),c date, d double,primary key(a,c));
     5  insert into ct_07 values (1,'901','2011-09-29',0.01),(2,'187','2011-09-29',1.31),(3,'90','2111-02-09',10.01);
     6  begin;
     7  insert into ct_07 values (3,'90','2111-02-09',10.01);
     8  insert into ct_07 values (4,'11','2011-09-29',7.00),(2,'567','2011-09-29',1.31),(4,'90','2011-09-29',89.3);
     9  (Duplicate entry) '\((\d+),(\d{4}-\d{2}-\d{2})\)' (for key '__mo_cpkey_col')
    10  select * from ct_07;
    11  a    b    c    d
    12  3    90    2111-02-09    10.01
    13  1    901    2011-09-29    0.01
    14  2    187    2011-09-29    1.31
    15  3    90    2111-02-09    10.01
    16  commit;
    17  Duplicate entry '3a150341170bc28c' for key '__mo_cpkey_col'
    18  select * from ct_07;
    19  a    b    c    d
    20  1    901    2011-09-29    0.01
    21  2    187    2011-09-29    1.31
    22  3    90    2111-02-09    10.01
    23  create table dis_table_02(a int not null auto_increment,b varchar(25) not null,c datetime,primary key(a),key bstr (b),key cdate (c) );
    24  insert into dis_table_02(b,c) values ('aaaa','2020-09-08');
    25  insert into dis_table_02(b,c) values ('aaaa','2020-09-08');
    26  create table dis_table_03(b varchar(25) primary key,c datetime);
    27  begin ;
    28  insert into dis_table_03 select b,c from dis_table_02;
    29  Duplicate entry 'aaaa' for key 'b'
    30  select * from dis_table_03;
    31  b    c
    32  use special;
    33  insert into dis_table_03 select 'bbb','2012-09-30';
    34  update dis_table_03 set b='aaa';
    35  select * from dis_table_03;
    36  b    c
    37  aaa    2012-09-30 00:00:00
    38  use special;
    39  select * from dis_table_03;
    40  b    c
    41  aaa    2012-09-30 00:00:00
    42  truncate table dis_table_03;
    43  insert into dis_table_03 select 'bbb','2012-09-30';
    44  select * from dis_table_03;
    45  b    c
    46  bbb    2012-09-30 00:00:00
    47  commit;
    48  w-w conflict
    49  select * from dis_table_03;
    50  b    c
    51  create database if not exists iso_db_02;
    52  start transaction ;
    53  use special;
    54  show tables;
    55  Tables_in_special
    56  ct_07
    57  dis_table_02
    58  dis_table_03
    59  begin ;
    60  use special;
    61  create table iso_table_0001(a int);
    62  insert into iso_table_0001 values (2);
    63  no such table special.iso_table_0001
    64  use special;
    65  create table iso_table_0001(a int);
    66  drop database iso_db_02;
    67  commit;
    68  w-w conflict
    69  create table iso_table_0001(a int);
    70  commit;
    71  w-w conflict
    72  use special;
    73  select * from iso_table_0001;
    74  a
    75  drop database if exists special;