github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/plan_cache/plan_cache.test (about)

     1  drop table if exists test1;
     2  create table test1(t timestamp);
     3  insert into test1 values(now());
     4  insert into test1 values(now());
     5  insert into test1 values(now());
     6  insert into test1 values(now());
     7  select count(1) from test1 group by t;
     8  
     9  drop table if exists test2;
    10  create table test2(s char(26));
    11  insert into test2 values(substr(now(),1,26));
    12  insert into test2 values(substr(now(),1,26));
    13  insert into test2 values(substr(now(),1,26));
    14  insert into test2 values(substr(now(),1,26));
    15  select count(1) from test2 group by s;
    16  
    17  drop table if exists test3;
    18  create table test3(s char(25));
    19  insert into test3 values(substr(substr(now(),1,26),2,25));
    20  insert into test3 values(substr(substr(now(),1,26),2,25));
    21  insert into test3 values(substr(substr(now(),1,26),2,25));
    22  insert into test3 values(substr(substr(now(),1,26),2,25));
    23  select count(1) from test3 group by s;