vitess.io/vitess@v0.16.2/go/vt/vtexplain/testdata/twopc-output/unsharded-output.txt (about)

     1  ----------------------------------------------------------------------
     2  show tables from ks_unsharded
     3  
     4  1 ks_unsharded/-: show tables
     5  
     6  ----------------------------------------------------------------------
     7  select * from t1
     8  
     9  1 ks_unsharded/-: select * from t1 limit 10001
    10  
    11  ----------------------------------------------------------------------
    12  insert into t1 (id,intval,floatval) values (1,2,3.14)
    13  
    14  1 ks_unsharded/-: begin
    15  1 ks_unsharded/-: insert into t1(id, intval, floatval) values (1, 2, 3.14)
    16  2 ks_unsharded/-: commit
    17  
    18  ----------------------------------------------------------------------
    19  update t1 set intval = 10
    20  
    21  1 ks_unsharded/-: begin
    22  1 ks_unsharded/-: select id from t1 limit 10001 for update
    23  1 ks_unsharded/-: update t1 set intval = 10 where id in (1)
    24  2 ks_unsharded/-: commit
    25  
    26  ----------------------------------------------------------------------
    27  update t1 set floatval = 9.99
    28  
    29  1 ks_unsharded/-: begin
    30  1 ks_unsharded/-: select id from t1 limit 10001 for update
    31  1 ks_unsharded/-: update t1 set floatval = 9.99 where id in (1)
    32  2 ks_unsharded/-: commit
    33  
    34  ----------------------------------------------------------------------
    35  delete from t1 where id = 100
    36  
    37  1 ks_unsharded/-: begin
    38  1 ks_unsharded/-: delete from t1 where id in (100)
    39  2 ks_unsharded/-: commit
    40  
    41  ----------------------------------------------------------------------
    42  insert into t1 (id,intval,floatval) values (1,2,3.14) on duplicate key update intval=3, floatval=3.14
    43  
    44  1 ks_unsharded/-: begin
    45  1 ks_unsharded/-: insert into t1(id, intval, floatval) values (1, 2, 3.14) on duplicate key update intval = 3, floatval = 3.14
    46  2 ks_unsharded/-: commit
    47  
    48  ----------------------------------------------------------------------