github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/plan_cache/plan_cache.result (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  count(1)
     9  1
    10  1
    11  1
    12  1
    13  drop table if exists test2;
    14  create table test2(s char(26));
    15  insert into test2 values(substr(now(),1,26));
    16  insert into test2 values(substr(now(),1,26));
    17  insert into test2 values(substr(now(),1,26));
    18  insert into test2 values(substr(now(),1,26));
    19  select count(1) from test2 group by s;
    20  count(1)
    21  1
    22  1
    23  1
    24  1
    25  drop table if exists test3;
    26  create table test3(s char(25));
    27  insert into test3 values(substr(substr(now(),1,26),2,25));
    28  insert into test3 values(substr(substr(now(),1,26),2,25));
    29  insert into test3 values(substr(substr(now(),1,26),2,25));
    30  insert into test3 values(substr(substr(now(),1,26),2,25));
    31  select count(1) from test3 group by s;
    32  count(1)
    33  1
    34  1
    35  1
    36  1