vitess.io/vitess@v0.16.2/go/vt/vtexplain/testdata/multi-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/-: insert into t1(id, intval, floatval) values (1, 2, 3.14)
    15  
    16  ----------------------------------------------------------------------
    17  update t1 set intval = 10
    18  
    19  1 ks_unsharded/-: begin
    20  1 ks_unsharded/-: update t1 set intval = 10 limit 10001
    21  1 ks_unsharded/-: commit
    22  
    23  ----------------------------------------------------------------------
    24  update t1 set floatval = 9.99
    25  
    26  1 ks_unsharded/-: begin
    27  1 ks_unsharded/-: update t1 set floatval = 9.99 limit 10001
    28  1 ks_unsharded/-: commit
    29  
    30  ----------------------------------------------------------------------
    31  delete from t1 where id = 100
    32  
    33  1 ks_unsharded/-: begin
    34  1 ks_unsharded/-: delete from t1 where id = 100 limit 10001
    35  1 ks_unsharded/-: commit
    36  
    37  ----------------------------------------------------------------------
    38  insert into t1 (id,intval,floatval) values (1,2,3.14) on duplicate key update intval=3, floatval=3.14
    39  
    40  1 ks_unsharded/-: insert into t1(id, intval, floatval) values (1, 2, 3.14) on duplicate key update intval = 3, floatval = 3.14
    41  
    42  ----------------------------------------------------------------------
    43  select ID from t1
    44  
    45  1 ks_unsharded/-: select ID from t1 limit 10001
    46  
    47  ----------------------------------------------------------------------
    48  select t1.id, t2.c2 from t1 join t2 on t1.id = t2.t1_id where t2.c2 in (1)
    49  
    50  1 ks_unsharded/-: select t1.id, t2.c2 from t1 join t2 on t1.id = t2.t1_id where t2.c2 in (1) limit 10001
    51  
    52  ----------------------------------------------------------------------