Changeset: b87e719d00d6 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b87e719d00d6 Modified Files: clients/Tests/MAL-signatures_sphinxclient.stable.out Branch: default Log Message:
updated MAL-signatures_sphinxclient.stable.out for default diffs (truncated from 1839 to 300 lines): diff --git a/clients/Tests/MAL-signatures_sphinxclient.stable.out b/clients/Tests/MAL-signatures_sphinxclient.stable.out --- a/clients/Tests/MAL-signatures_sphinxclient.stable.out +++ b/clients/Tests/MAL-signatures_sphinxclient.stable.out @@ -26,60 +26,116 @@ Ready. # 00:44:35 > #?*) +command aggr.avg(b:bat[:oid,:dbl],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) +address AGGRavg23_dbl; +comment Grouped tail average on dbl, also returns count + +command aggr.avg(b:bat[:oid,:dbl],e:bat[:oid,:any_1]) (X_3:bat[:oid,:dbl],X_4:bat[:oid,:wrd]) +address AGGRavg22_dbl; +comment Grouped tail average on dbl, also returns count + command aggr.avg(b:bat[:oid,:dbl],g:bat[:oid,:oid],e:bat[:oid,:any_1]):bat[:oid,:dbl] -address AGGRavg3_dbl; +address AGGRavg13_dbl; comment Grouped tail average on dbl command aggr.avg(b:bat[:oid,:dbl],e:bat[:oid,:any_1]):bat[:oid,:dbl] -address AGGRavg2_dbl; +address AGGRavg12_dbl; comment Grouped tail average on dbl +command aggr.avg(b:bat[:oid,:flt],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) +address AGGRavg23_dbl; +comment Grouped tail average on flt, also returns count + +command aggr.avg(b:bat[:oid,:flt],e:bat[:oid,:any_1]) (X_3:bat[:oid,:dbl],X_4:bat[:oid,:wrd]) +address AGGRavg22_dbl; +comment Grouped tail average on flt, also returns count + command aggr.avg(b:bat[:oid,:flt],g:bat[:oid,:oid],e:bat[:oid,:any_1]):bat[:oid,:dbl] -address AGGRavg3_dbl; +address AGGRavg13_dbl; comment Grouped tail average on flt command aggr.avg(b:bat[:oid,:flt],e:bat[:oid,:any_1]):bat[:oid,:dbl] -address AGGRavg2_dbl; +address AGGRavg12_dbl; comment Grouped tail average on flt +command aggr.avg(b:bat[:oid,:lng],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) +address AGGRavg23_dbl; +comment Grouped tail average on lng, also returns count + +command aggr.avg(b:bat[:oid,:lng],e:bat[:oid,:any_1]) (X_3:bat[:oid,:dbl],X_4:bat[:oid,:wrd]) +address AGGRavg22_dbl; +comment Grouped tail average on lng, also returns count + command aggr.avg(b:bat[:oid,:lng],g:bat[:oid,:oid],e:bat[:oid,:any_1]):bat[:oid,:dbl] -address AGGRavg3_dbl; +address AGGRavg13_dbl; comment Grouped tail average on lng command aggr.avg(b:bat[:oid,:lng],e:bat[:oid,:any_1]):bat[:oid,:dbl] -address AGGRavg2_dbl; +address AGGRavg12_dbl; comment Grouped tail average on lng +command aggr.avg(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) +address AGGRavg23_dbl; +comment Grouped tail average on wrd, also returns count + +command aggr.avg(b:bat[:oid,:wrd],e:bat[:oid,:any_1]) (X_3:bat[:oid,:dbl],X_4:bat[:oid,:wrd]) +address AGGRavg22_dbl; +comment Grouped tail average on wrd, also returns count + command aggr.avg(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1]):bat[:oid,:dbl] -address AGGRavg3_dbl; +address AGGRavg13_dbl; comment Grouped tail average on wrd command aggr.avg(b:bat[:oid,:wrd],e:bat[:oid,:any_1]):bat[:oid,:dbl] -address AGGRavg2_dbl; +address AGGRavg12_dbl; comment Grouped tail average on wrd +command aggr.avg(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) +address AGGRavg23_dbl; +comment Grouped tail average on int, also returns count + +command aggr.avg(b:bat[:oid,:int],e:bat[:oid,:any_1]) (X_3:bat[:oid,:dbl],X_4:bat[:oid,:wrd]) +address AGGRavg22_dbl; +comment Grouped tail average on int, also returns count + command aggr.avg(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1]):bat[:oid,:dbl] -address AGGRavg3_dbl; +address AGGRavg13_dbl; comment Grouped tail average on int command aggr.avg(b:bat[:oid,:int],e:bat[:oid,:any_1]):bat[:oid,:dbl] -address AGGRavg2_dbl; +address AGGRavg12_dbl; comment Grouped tail average on int +command aggr.avg(b:bat[:oid,:sht],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) +address AGGRavg23_dbl; +comment Grouped tail average on sht, also returns count + +command aggr.avg(b:bat[:oid,:sht],e:bat[:oid,:any_1]) (X_3:bat[:oid,:dbl],X_4:bat[:oid,:wrd]) +address AGGRavg22_dbl; +comment Grouped tail average on sht, also returns count + command aggr.avg(b:bat[:oid,:sht],g:bat[:oid,:oid],e:bat[:oid,:any_1]):bat[:oid,:dbl] -address AGGRavg3_dbl; +address AGGRavg13_dbl; comment Grouped tail average on sht command aggr.avg(b:bat[:oid,:sht],e:bat[:oid,:any_1]):bat[:oid,:dbl] -address AGGRavg2_dbl; +address AGGRavg12_dbl; comment Grouped tail average on sht +command aggr.avg(b:bat[:oid,:bte],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) +address AGGRavg23_dbl; +comment Grouped tail average on bte, also returns count + +command aggr.avg(b:bat[:oid,:bte],e:bat[:oid,:any_1]) (X_3:bat[:oid,:dbl],X_4:bat[:oid,:wrd]) +address AGGRavg22_dbl; +comment Grouped tail average on bte, also returns count + command aggr.avg(b:bat[:oid,:bte],g:bat[:oid,:oid],e:bat[:oid,:any_1]):bat[:oid,:dbl] -address AGGRavg3_dbl; +address AGGRavg13_dbl; comment Grouped tail average on bte command aggr.avg(b:bat[:oid,:bte],e:bat[:oid,:any_1]):bat[:oid,:dbl] -address AGGRavg2_dbl; +address AGGRavg12_dbl; comment Grouped tail average on bte command aggr.avg(b:bat[:any_1,:dbl]):dbl @@ -193,62 +249,6 @@ command aggr.max(b:bat[:oid,:any_1],e:ba address AGGRmax2; command aggr.min(b:bat[:oid,:any_1],e:bat[:oid,:any_2]):bat[:oid,:any_1] address AGGRmin2; -command aggr.min(b:bat[:any_1,:lng]):lng -address ALGmin_lng; -comment Give the lowest tail value. - -command aggr.min(b:bat[:any_1,:dbl]):dbl -address ALGmin_dbl; -comment Give the lowest tail value. - -command aggr.min(b:bat[:any_1,:flt]):flt -address ALGmin_flt; -comment Give the lowest tail value. - -command aggr.min(b:bat[:any_1,:wrd]):wrd -address ALGmin_wrd; -comment Give the lowest tail value. - -command aggr.min(b:bat[:any_1,:int]):int -address ALGmin_int; -comment Give the lowest tail value. - -command aggr.min(b:bat[:any_1,:sht]):sht -address ALGmin_sht; -comment Give the lowest tail value. - -command aggr.min(b:bat[:any_1,:bte]):bte -address ALGmin_bte; -comment Give the lowest tail value. - -command aggr.max(b:bat[:any_1,:lng]):lng -address ALGmax_lng; -comment Give the highest tail value. - -command aggr.max(b:bat[:any_1,:dbl]):dbl -address ALGmax_dbl; -comment Give the highest tail value. - -command aggr.max(b:bat[:any_1,:flt]):flt -address ALGmax_flt; -comment Give the highest tail value. - -command aggr.max(b:bat[:any_1,:wrd]):wrd -address ALGmax_wrd; -comment Give the highest tail value. - -command aggr.max(b:bat[:any_1,:int]):int -address ALGmax_int; -comment Give the highest tail value. - -command aggr.max(b:bat[:any_1,:sht]):sht -address ALGmax_sht; -comment Give the highest tail value. - -command aggr.max(b:bat[:any_1,:bte]):bte -address ALGmax_bte; -comment Give the highest tail value. - command aggr.max(b:bat[:any_1,:any_2]):any_2 address ALGmaxany; comment Return the highest tail value or nil. @@ -769,6 +769,23 @@ pattern aggr.prod(b:bat[:oid,:bte]):bte address CMDBATprod; comment Calculate aggregate product of B. +function aggr.quantile(b:bat[:oid,:any_1],q:bat[:oid,:dbl]):any_1; +command aggr.quantile(b:bat[:oid,:any_1],g:bat[:oid,:oid],e:bat[:oid,:any_2],q:bat[:oid,:dbl]):bat[:oid,:any_1] +address AGGRquantile3; +comment Grouped quantile aggregate + +command aggr.subquantile(b:bat[:oid,:any_1],q:bat[:oid,:dbl],g:bat[:oid,:oid],e:bat[:oid,:any_2],s:bat[:oid,:oid],skip_nils:bit):bat[:oid,:any_1] +address AGGRsubquantilecand; +comment Grouped median quantile with candidate list + +command aggr.subquantile(b:bat[:oid,:any_1],q:bat[:oid,:dbl],g:bat[:oid,:oid],e:bat[:oid,:any_2],skip_nils:bit):bat[:oid,:any_1] +address AGGRsubquantile; +comment Grouped quantile aggregate + +command aggr.subquantile(b:bat[:oid,:any_1],q:bat[:oid,:dbl],skip_nils:bit):bat[:oid,:any_1] +address AGGRquantile; +comment Quantile aggregate + command aggr.submedian(b:bat[:oid,:any_1],g:bat[:oid,:oid],e:bat[:oid,:any_2],s:bat[:oid,:oid],skip_nils:bit):bat[:oid,:any_1] address AGGRsubmediancand; comment Grouped median aggregate with candidate list @@ -873,12 +890,20 @@ command aggr.stdev(b:bat[:oid,:dbl],e:ba address AGGRstdev2_dbl; comment Grouped tail standard deviation (sample/non-biased) on dbl +command aggr.subavg(b:bat[:oid,:dbl],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:bit,abort_on_error:bit) (X_7:bat[:oid,:dbl],X_8:bat[:oid,:wrd]) +address AGGRsubavg2cand_dbl; +comment Grouped average aggregate with candidates list, also returns count + +command aggr.subavg(b:bat[:oid,:dbl],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:bit,abort_on_error:bit) (X_6:bat[:oid,:dbl],X_7:bat[:oid,:wrd]) +address AGGRsubavg2_dbl; +comment Grouped average aggregate, also returns count + command aggr.subavg(b:bat[:oid,:dbl],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:bit,abort_on_error:bit):bat[:oid,:dbl] -address AGGRsubavgcand_dbl; +address AGGRsubavg1cand_dbl; comment Grouped average aggregate with candidates list command aggr.subavg(b:bat[:oid,:dbl],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:bit,abort_on_error:bit):bat[:oid,:dbl] -address AGGRsubavg_dbl; +address AGGRsubavg1_dbl; comment Grouped average aggregate command aggr.subvariancep(b:bat[:oid,:flt],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:bit,abort_on_error:bit):bat[:oid,:dbl] @@ -929,12 +954,20 @@ command aggr.stdev(b:bat[:oid,:flt],e:ba address AGGRstdev2_dbl; comment Grouped tail standard deviation (sample/non-biased) on flt +command aggr.subavg(b:bat[:oid,:flt],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:bit,abort_on_error:bit) (X_7:bat[:oid,:dbl],X_8:bat[:oid,:wrd]) +address AGGRsubavg2cand_dbl; +comment Grouped average aggregate with candidates list, also returns count + +command aggr.subavg(b:bat[:oid,:flt],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:bit,abort_on_error:bit) (X_6:bat[:oid,:dbl],X_7:bat[:oid,:wrd]) +address AGGRsubavg2_dbl; +comment Grouped average aggregate, also returns count + command aggr.subavg(b:bat[:oid,:flt],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:bit,abort_on_error:bit):bat[:oid,:dbl] -address AGGRsubavgcand_dbl; +address AGGRsubavg1cand_dbl; comment Grouped average aggregate with candidates list command aggr.subavg(b:bat[:oid,:flt],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:bit,abort_on_error:bit):bat[:oid,:dbl] -address AGGRsubavg_dbl; +address AGGRsubavg1_dbl; comment Grouped average aggregate command aggr.subvariancep(b:bat[:oid,:lng],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:bit,abort_on_error:bit):bat[:oid,:dbl] @@ -985,12 +1018,20 @@ command aggr.stdev(b:bat[:oid,:lng],e:ba address AGGRstdev2_dbl; comment Grouped tail standard deviation (sample/non-biased) on lng +command aggr.subavg(b:bat[:oid,:lng],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:bit,abort_on_error:bit) (X_7:bat[:oid,:dbl],X_8:bat[:oid,:wrd]) +address AGGRsubavg2cand_dbl; +comment Grouped average aggregate with candidates list, also returns count + +command aggr.subavg(b:bat[:oid,:lng],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:bit,abort_on_error:bit) (X_6:bat[:oid,:dbl],X_7:bat[:oid,:wrd]) +address AGGRsubavg2_dbl; +comment Grouped average aggregate, also returns count + command aggr.subavg(b:bat[:oid,:lng],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:bit,abort_on_error:bit):bat[:oid,:dbl] -address AGGRsubavgcand_dbl; +address AGGRsubavg1cand_dbl; comment Grouped average aggregate with candidates list command aggr.subavg(b:bat[:oid,:lng],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:bit,abort_on_error:bit):bat[:oid,:dbl] -address AGGRsubavg_dbl; +address AGGRsubavg1_dbl; comment Grouped average aggregate command aggr.subvariancep(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:bit,abort_on_error:bit):bat[:oid,:dbl] @@ -1041,12 +1082,20 @@ command aggr.stdev(b:bat[:oid,:wrd],e:ba address AGGRstdev2_dbl; comment Grouped tail standard deviation (sample/non-biased) on wrd +command aggr.subavg(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:bit,abort_on_error:bit) (X_7:bat[:oid,:dbl],X_8:bat[:oid,:wrd]) +address AGGRsubavg2cand_dbl; +comment Grouped average aggregate with candidates list, also returns count + +command aggr.subavg(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:bit,abort_on_error:bit) (X_6:bat[:oid,:dbl],X_7:bat[:oid,:wrd]) +address AGGRsubavg2_dbl; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
