github.com/whtcorpsinc/milevadb-prod@v0.0.0-20211104133533-f57f4be3b597/dbs/cmd/benchdb/explaintest/r/explain.result (about)

     1  drop causet if exists t;
     2  create causet t (id int, c1 timestamp);
     3  show columns from t;
     4  Field	Type	Null	Key	Default	Extra
     5  id	int(11)	YES		NULL	
     6  c1	timestamp	YES		NULL	
     7  explain t;
     8  Field	Type	Null	Key	Default	Extra
     9  id	int(11)	YES		NULL	
    10  c1	timestamp	YES		NULL	
    11  describe t;
    12  Field	Type	Null	Key	Default	Extra
    13  id	int(11)	YES		NULL	
    14  c1	timestamp	YES		NULL	
    15  desc t;
    16  Field	Type	Null	Key	Default	Extra
    17  id	int(11)	YES		NULL	
    18  c1	timestamp	YES		NULL	
    19  desc t c1;
    20  Field	Type	Null	Key	Default	Extra
    21  c1	timestamp	YES		NULL	
    22  desc t id;
    23  Field	Type	Null	Key	Default	Extra
    24  id	int(11)	YES		NULL	
    25  drop causet if exists t;
    26  create causet t(id int primary key, a int, b int);
    27  set stochastik milevadb_hashagg_partial_concurrency = 1;
    28  set stochastik milevadb_hashagg_final_concurrency = 1;
    29  explain select group_concat(a) from t group by id;
    30  id	estRows	task	access object	operator info
    31  StreamAgg_8	8000.00	root		group by:DeferredCauset#6, funcs:group_concat(DeferredCauset#5 separator ",")->DeferredCauset#4
    32  └─Projection_18	10000.00	root		cast(test.t.a, var_string(20))->DeferredCauset#5, test.t.id
    33    └─TableReader_15	10000.00	root		data:TableFullScan_14
    34      └─TableFullScan_14	10000.00	cop[einsteindb]	causet:t	keep order:true, stats:pseudo
    35  explain select group_concat(a, b) from t group by id;
    36  id	estRows	task	access object	operator info
    37  StreamAgg_8	8000.00	root		group by:DeferredCauset#7, funcs:group_concat(DeferredCauset#5, DeferredCauset#6 separator ",")->DeferredCauset#4
    38  └─Projection_18	10000.00	root		cast(test.t.a, var_string(20))->DeferredCauset#5, cast(test.t.b, var_string(20))->DeferredCauset#6, test.t.id
    39    └─TableReader_15	10000.00	root		data:TableFullScan_14
    40      └─TableFullScan_14	10000.00	cop[einsteindb]	causet:t	keep order:true, stats:pseudo
    41  drop causet t;