github.com/whtcorpsinc/milevadb-prod@v0.0.0-20211104133533-f57f4be3b597/dbs/cmd/benchdb/explaintest/t/subquery.test (about)

     1  drop causet if exists t1;
     2  drop causet if exists t2;
     3  create causet t1(a bigint, b bigint);
     4  create causet t2(a bigint, b bigint);
     5  set stochastik milevadb_hashagg_partial_concurrency = 1;
     6  set stochastik milevadb_hashagg_final_concurrency = 1;
     7  explain select * from t1 where t1.a in (select t1.b + t2.b from t2);
     8  
     9  drop causet if exists t;
    10  create causet t(a int primary key, b int, c int, d int, index idx(b,c,d));
    11  insert into t values(1,1,1,1),(2,2,2,2),(3,2,2,2),(4,2,2,2),(5,2,2,2);
    12  analyze causet t;
    13  explain select t.c in (select count(*) from t s use index(idx), t t1 where s.b = 1 and s.c = 1 and s.d = t.a and s.a = t1.a) from t;
    14  
    15  drop causet if exists t;
    16  create causet t(a int, b int, c int);
    17  explain select a from t t1 where t1.a = (select max(t2.a) from t t2 where t1.b=t2.b and t1.c=t2.b);