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;