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

     1  ----------------------------------------------------------------------
     2  insert into user (id, name) values(1, 'alice')
     3  
     4  1 ks_sharded/40-80: begin
     5  1 ks_sharded/40-80: insert into name_user_map(`name`, user_id) values ('alice', 1)
     6  2 ks_sharded/-40: begin
     7  2 ks_sharded/-40: insert into `user`(id, `name`) values (1, 'alice')
     8  3 ks_sharded/40-80: commit
     9  4 ks_sharded/-40: commit
    10  
    11  ----------------------------------------------------------------------
    12  insert into user (id, name) values(2, 'bob')
    13  
    14  1 ks_sharded/c0-: begin
    15  1 ks_sharded/c0-: insert into name_user_map(`name`, user_id) values ('bob', 2)
    16  2 ks_sharded/-40: begin
    17  2 ks_sharded/-40: insert into `user`(id, `name`) values (2, 'bob')
    18  3 ks_sharded/c0-: commit
    19  4 ks_sharded/-40: commit
    20  
    21  ----------------------------------------------------------------------
    22  insert ignore into user (id, name) values(2, 'bob')
    23  
    24  1 ks_sharded/c0-: begin
    25  1 ks_sharded/c0-: insert ignore into name_user_map(`name`, user_id) values ('bob', 2)
    26  2 ks_sharded/c0-: select `name` from name_user_map where `name` = 'bob' and user_id = 2 limit 10001
    27  3 ks_sharded/-40: begin
    28  3 ks_sharded/-40: insert ignore into `user`(id, `name`) values (2, 'bob')
    29  4 ks_sharded/c0-: commit
    30  5 ks_sharded/-40: commit
    31  
    32  ----------------------------------------------------------------------
    33  insert ignore into user (id, name, nickname) values(2, 'bob', 'bob')
    34  
    35  1 ks_sharded/c0-: begin
    36  1 ks_sharded/c0-: insert ignore into name_user_map(`name`, user_id) values ('bob', 2)
    37  2 ks_sharded/c0-: select `name` from name_user_map where `name` = 'bob' and user_id = 2 limit 10001
    38  3 ks_sharded/-40: begin
    39  3 ks_sharded/-40: insert ignore into `user`(id, `name`, nickname) values (2, 'bob', 'bob')
    40  4 ks_sharded/c0-: commit
    41  5 ks_sharded/-40: commit
    42  
    43  ----------------------------------------------------------------------
    44  insert into user (id, name, nickname) values(2, 'bob', 'bobby') on duplicate key update nickname='bobby'
    45  
    46  1 ks_sharded/c0-: begin
    47  1 ks_sharded/c0-: insert ignore into name_user_map(`name`, user_id) values ('bob', 2)
    48  2 ks_sharded/c0-: select `name` from name_user_map where `name` = 'bob' and user_id = 2 limit 10001
    49  3 ks_sharded/-40: begin
    50  3 ks_sharded/-40: insert into `user`(id, `name`, nickname) values (2, 'bob', 'bobby') on duplicate key update nickname = 'bobby'
    51  4 ks_sharded/c0-: commit
    52  5 ks_sharded/-40: commit
    53  
    54  ----------------------------------------------------------------------
    55  insert into user (id, name, nickname, address) values(2, 'bob', 'bobby', '123 main st') on duplicate key update nickname=values(nickname), address=values(address)
    56  
    57  1 ks_sharded/c0-: begin
    58  1 ks_sharded/c0-: insert ignore into name_user_map(`name`, user_id) values ('bob', 2)
    59  2 ks_sharded/c0-: select `name` from name_user_map where `name` = 'bob' and user_id = 2 limit 10001
    60  3 ks_sharded/-40: begin
    61  3 ks_sharded/-40: insert into `user`(id, `name`, nickname, address) values (2, 'bob', 'bobby', '123 main st') on duplicate key update nickname = values(nickname), address = values(address)
    62  4 ks_sharded/c0-: commit
    63  5 ks_sharded/-40: commit
    64  
    65  ----------------------------------------------------------------------
    66  insert /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ into music_extra (id, extra) values (1, 'a'), (2, 'b'), (3, 'c')
    67  
    68  1 ks_sharded/-40: insert /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ into music_extra(id, extra) values (1, 'a'), (2, 'b')
    69  1 ks_sharded/40-80: insert /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ into music_extra(id, extra) values (3, 'c')
    70  
    71  ----------------------------------------------------------------------
    72  begin
    73  
    74  
    75  ----------------------------------------------------------------------
    76  insert into member (lkp, more_id, id) values ("a", 1, 1), ("b", 1, 3), ("c", 1, 1) on duplicate key update more_id = 2
    77  
    78  1 ks_sharded/40-80: insert /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ ignore into lkp_idx(lkp, id) values ('b', 3), ('c', 1)
    79  1 ks_sharded/c0-: insert /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ ignore into lkp_idx(lkp, id) values ('a', 1)
    80  2 ks_sharded/c0-: select lkp from lkp_idx where lkp = 'a' and id = 1 limit 10001
    81  3 ks_sharded/40-80: select lkp from lkp_idx where lkp = 'b' and id = 3 limit 10001
    82  4 ks_sharded/40-80: select lkp from lkp_idx where lkp = 'c' and id = 1 limit 10001
    83  5 ks_sharded/-40: begin
    84  5 ks_sharded/-40: savepoint x1
    85  5 ks_sharded/-40: insert into `member`(lkp, more_id, id) values ('a', 1, 1), ('c', 1, 1) on duplicate key update more_id = 2
    86  5 ks_sharded/40-80: begin
    87  5 ks_sharded/40-80: savepoint x1
    88  5 ks_sharded/40-80: insert into `member`(lkp, more_id, id) values ('b', 1, 3) on duplicate key update more_id = 2
    89  
    90  ----------------------------------------------------------------------
    91  commit
    92  
    93  6 ks_sharded/-40: commit
    94  7 ks_sharded/40-80: commit
    95  
    96  ----------------------------------------------------------------------