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

     1  drop table if exists dis_table_02;
     2  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) );
     3  insert into dis_table_02(b,c) values ('aaaa','2020-09-08');
     4  insert into dis_table_02(b,c) values ('aaaa','2020-09-08');
     5  
     6  begin;
     7  update dis_table_02 set b='tittttt' where a>1;
     8  
     9  -- @session:id=1{
    10  use ww_conflict;
    11  begin;
    12  update dis_table_02 set b='dpqweoe' where a>1;
    13  -- @session}
    14  
    15  commit;
    16  
    17  -- @session:id=1{
    18  start transaction;
    19  -- @session}
    20  
    21  drop table if exists dis_table_02;