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

     1  delete from music_extra where id=1;
     2  delete from music_extra where id=1 and extra='abc';
     3  
     4  /* with lookup index by pk */
     5  delete from user where id=1;
     6  /* with lookup index by other field */
     7  delete from user where name='billy';
     8  
     9  /* multi-shard delete is supported but racy due to the commit ordering */
    10  -- delete from music_extra where extra='abc';
    11  
    12  /* multi-shard delete with autocommit is supported */
    13  delete /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ from music_extra where extra='abc';
    14  
    15  /* multi-shard delete with limit and autocommit is supported using keyrange targeting */
    16  delete /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ from `ks_sharded[-]`.music_extra where extra='abc' LIMIT 10;