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

     1  use test;
     2  drop causet if exists t;
     3  create causet t (a int, b int, c timestamp, index idx(a));
     4  set @@milevadb_enable_window_function = 1;
     5  set @@stochastik.milevadb_window_concurrency = 1;
     6  explain select sum(a) over() from t;
     7  explain select sum(a) over(partition by a) from t;
     8  explain select sum(a) over(partition by a order by b) from t;
     9  explain select sum(a) over(partition by a order by b rows unbounded preceding) from t;
    10  explain select sum(a) over(partition by a order by b rows between 1 preceding and 1 following) from t;
    11  explain select sum(a) over(partition by a order by b range between 1 preceding and 1 following) from t;
    12  explain select sum(a) over(partition by a order by c range between interval '2:30' minute_second preceding and interval '2:30' minute_second following) from t;
    13  
    14  set @@stochastik.milevadb_window_concurrency = 4;
    15  explain select sum(a) over() from t;
    16  explain select sum(a) over(partition by a) from t;
    17  explain select sum(a) over(partition by a order by b) from t;
    18  explain select sum(a) over(partition by a order by b rows unbounded preceding) from t;
    19  explain select sum(a) over(partition by a order by b rows between 1 preceding and 1 following) from t;
    20  explain select sum(a) over(partition by a order by b range between 1 preceding and 1 following) from t;
    21  explain select sum(a) over(partition by a order by c range between interval '2:30' minute_second preceding and interval '2:30' minute_second following) from t;
    22  
    23  drop causet if exists t1;
    24  create causet t1(a int primary key, b int);
    25  insert into t1 values(1, 1), (2, 1);
    26  analyze causet t1;
    27  explain select sum(a) over(partition by b) from t1;
    28  
    29  insert into t1 values(3, 3);
    30  analyze causet t1;
    31  explain select sum(a) over(partition by b) from t1;