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

     1  select * from user /* scatter */;
     2  select * from user where id = 1 /* equal unique */;
     3  select * from user where id > 100 /* scatter range */;
     4  select * from user where name = 'bob' /* vindex lookup */;
     5  select * from user where name = 'bob' or nickname = 'bob' /* vindex lookup */;
     6  
     7  select u.id, u.name, u.nickname, n.info from user u join name_info n on u.name = n.name /* join on varchar */;
     8  select m.id, m.song, e.extra from music m join music_extra e on m.id = e.id where m.user_id = 100 /* join on int */;
     9  
    10  select count(*) from user where id = 1 /* point aggregate */;
    11  select count(*) from user where name in ('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j') /* scatter aggregate */;
    12  select count(*) from customer where email in ('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j') /* scatter aggregate with batching */;
    13  select name, count(*) from user group by name /* scatter aggregate */;
    14  
    15  select 1, "hello", 3.14, null from user limit 10 /* select constant sql values */;
    16  select * from (select id from user) s /* scatter paren select */;
    17  
    18  select name from user where id = (select id from t1) /* non-correlated subquery as value */;
    19  select name from user where id in (select id from t1) /* non-correlated subquery in IN clause */;
    20  select name from user where id not in (select id from t1) /* non-correlated subquery in NOT IN clause */;
    21  select name from user where exists (select id from t1) /* non-correlated subquery as EXISTS */;
    22  
    23  select * from name_info order by info /* select * and order by varchar column */;
    24  
    25  select distinct(name) from user where id = 1 /* select distinct */;
    26  select distinct name from user where id = 1 /* select distinct */;
    27  
    28  select id, substring(name, 1, -1) from user where id = 123 /* select substring */;
    29  select id, substring_index(name, '123456', -1) from user where id = 123 /* select substring_index */;
    30  
    31  select id, case when name = 'alice' then 'ALICE' when name = 'bob' then 'BOB' end as name from user where id = 1 /* select case */;
    32  select id, case when name = 'alice' then 'ALICE' when name = 'bob' then 'BOB' else 'OTHER' end as name from user where id = 1 /* select case */;
    33  select id, case when substr(name, 1, 5) = 'alice' then 'ALICE' when name = 'bob' then 'BOB' else 'OTHER' end as name from user where id = 1 /* select case */;
    34  
    35  select id, 'abc' as test from user where id = 1 union all select id, 'def' as test from user where id = 1 union all select id, 'ghi' as test from user where id = 1 /* union all */;
    36  
    37  select id from user where not id in (select col from music where music.user_id = 42) and id in (select col from music where music.user_id = 411);
    38  
    39  SELECT user.id, user.name, name_info.info FROM user INNER JOIN music ON (user.id = music.user_id) LEFT OUTER JOIN name_info ON (user.name = name_info.name);
    40  
    41  SELECT id FROM orders WHERE id IN (1, "1", 1)