vitess.io/vitess@v0.16.2/go/vt/vtexplain/testdata/updatesharded-queries.sql (about)

     1  update user set nickname='alice' where id=1;
     2  update user set nickname='alice' where name='alice';
     3  update user set pet='fido' where id=1;
     4  
     5  /* update secondary vindex value */
     6  update user set name='alicia' where id=1;
     7  update user set name='alicia' where name='alice';
     8  
     9  /* scatter update -- supported but with nondeterministic output */
    10  /* update name_info set has_nickname=1 where nickname != ''; */
    11  
    12  /* scatter update autocommit */
    13  update /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ name_info set info='apa' where name != 'hog';
    14  
    15  /* multi-shard update by secondary vindex */
    16  update user set pet='rover' where name='alice';
    17  
    18  /* update in a transaction on one shard */
    19  begin;
    20  update user set nickname='alice' where id=1;
    21  update user set nickname='bob' where id=1;
    22  commit;
    23  
    24  /* update in a transaction on multiple shards */
    25  begin;
    26  update user set nickname='alice' where id=1;
    27  update user set nickname='bob' where id=3;
    28  commit;
    29  
    30  /* update in a transaction with single query going to multiple shard */
    31  begin;
    32  update user set nickname='alice' where id in (1,4);
    33  commit;