Changeset: 8426f8f3012c for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8426f8f3012c Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 Branch: default Log Message:
Approved after changeset 85e32a4ed063. diffs (truncated from 34912 to 300 lines): diff --git a/clients/Tests/MAL-signatures.stable.out b/clients/Tests/MAL-signatures.stable.out --- a/clients/Tests/MAL-signatures.stable.out +++ b/clients/Tests/MAL-signatures.stable.out @@ -60,399 +60,399 @@ Ready. % .L1, .L1, .L1, .L1, .L1 # table_name % module, function, signature, address, comment # name % clob, clob, clob, clob, clob # type -% 11, 28, 346, 44, 874 # length -[ "aggr", "avg", "command aggr.avg(b:bat[:bte],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on bte" ] -[ "aggr", "avg", "command aggr.avg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on dbl" ] -[ "aggr", "avg", "command aggr.avg(b:bat[:flt],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on flt" ] -[ "aggr", "avg", "command aggr.avg(b:bat[:int],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on int" ] -[ "aggr", "avg", "command aggr.avg(b:bat[:lng],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on lng" ] -[ "aggr", "avg", "command aggr.avg(b:bat[:sht],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on sht" ] -[ "aggr", "avg", "command aggr.avg(b:bat[:bte],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on bte, also returns count" ] -[ "aggr", "avg", "command aggr.avg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on dbl, also returns count" ] -[ "aggr", "avg", "command aggr.avg(b:bat[:flt],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on flt, also returns count" ] -[ "aggr", "avg", "command aggr.avg(b:bat[:int],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on int, also returns count" ] -[ "aggr", "avg", "command aggr.avg(b:bat[:lng],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on lng, also returns count" ] -[ "aggr", "avg", "command aggr.avg(b:bat[:sht],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on sht, also returns count" ] +% 11, 28, 364, 44, 874 # length +[ "aggr", "avg", "command aggr.avg(b:bat[:bte], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on bte" ] +[ "aggr", "avg", "command aggr.avg(b:bat[:dbl], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on dbl" ] +[ "aggr", "avg", "command aggr.avg(b:bat[:flt], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on flt" ] +[ "aggr", "avg", "command aggr.avg(b:bat[:int], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on int" ] +[ "aggr", "avg", "command aggr.avg(b:bat[:lng], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on lng" ] +[ "aggr", "avg", "command aggr.avg(b:bat[:sht], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on sht" ] +[ "aggr", "avg", "command aggr.avg(b:bat[:bte], g:bat[:oid], e:bat[:any_1]) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on bte, also returns count" ] +[ "aggr", "avg", "command aggr.avg(b:bat[:dbl], g:bat[:oid], e:bat[:any_1]) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on dbl, also returns count" ] +[ "aggr", "avg", "command aggr.avg(b:bat[:flt], g:bat[:oid], e:bat[:any_1]) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on flt, also returns count" ] +[ "aggr", "avg", "command aggr.avg(b:bat[:int], g:bat[:oid], e:bat[:any_1]) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on int, also returns count" ] +[ "aggr", "avg", "command aggr.avg(b:bat[:lng], g:bat[:oid], e:bat[:any_1]) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on lng, also returns count" ] +[ "aggr", "avg", "command aggr.avg(b:bat[:sht], g:bat[:oid], e:bat[:any_1]) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on sht, also returns count" ] [ "aggr", "avg", "pattern aggr.avg(b:bat[:any_2]):dbl ", "CMDcalcavg;", "Gives the avg of all tail values" ] [ "aggr", "cardinality", "command aggr.cardinality(b:bat[:any_2]):lng ", "ALGcard;", "Return the cardinality of the BAT tail values." ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:bte],e2:bat[:bte]):bte;", "", "" ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:dbl],e2:bat[:dbl]):dbl;", "", "" ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:flt],e2:bat[:flt]):flt;", "", "" ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:int],e2:bat[:int]):int;", "", "" ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:lng],e2:bat[:lng]):lng;", "", "" ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:sht],e2:bat[:sht]):sht;", "", "" ] -[ "aggr", "count", "command aggr.count(b:bat[:any_1],g:bat[:oid],e:bat[:any_2],ignorenils:bit):bat[:lng] ", "AGGRcount3;", "" ] -[ "aggr", "count", "command aggr.count(b:bat[:any_1],g:bat[:oid],e:bat[:any_2]):bat[:lng] ", "AGGRcount3nils;", "Grouped count" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:bte], e2:bat[:bte]):bte;", "", "" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:dbl], e2:bat[:dbl]):dbl;", "", "" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:flt], e2:bat[:flt]):flt;", "", "" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:int], e2:bat[:int]):int;", "", "" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:lng], e2:bat[:lng]):lng;", "", "" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:sht], e2:bat[:sht]):sht;", "", "" ] +[ "aggr", "count", "command aggr.count(b:bat[:any_1], g:bat[:oid], e:bat[:any_2], ignorenils:bit):bat[:lng] ", "AGGRcount3;", "" ] +[ "aggr", "count", "command aggr.count(b:bat[:any_1], g:bat[:oid], e:bat[:any_2]):bat[:lng] ", "AGGRcount3nils;", "Grouped count" ] [ "aggr", "count", "command aggr.count(b:bat[:any]):lng ", "ALGcount_bat;", "Return the current size (in number of elements) in a BAT." ] -[ "aggr", "count", "command aggr.count(b:bat[:any],ignore_nils:bit):lng ", "ALGcount_nil;", "Return the number of elements currently in a BAT ignores\n\t\tBUNs with nil-tail iff ignore_nils==TRUE." ] -[ "aggr", "count_no_nil", "command aggr.count_no_nil(b:bat[:any_1],g:bat[:oid],e:bat[:any_2]):bat[:lng] ", "AGGRcount3nonils;", "" ] +[ "aggr", "count", "command aggr.count(b:bat[:any], ignore_nils:bit):lng ", "ALGcount_nil;", "Return the number of elements currently in a BAT ignores\n\t\tBUNs with nil-tail iff ignore_nils==TRUE." ] +[ "aggr", "count_no_nil", "command aggr.count_no_nil(b:bat[:any_1], g:bat[:oid], e:bat[:any_2]):bat[:lng] ", "AGGRcount3nonils;", "" ] [ "aggr", "count_no_nil", "command aggr.count_no_nil(b:bat[:any_2]):lng ", "ALGcount_no_nil;", "Return the number of elements currently\n\tin a BAT ignoring BUNs with nil-tail" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:bte],e2:bat[:bte]):bte;", "", "" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:dbl],e2:bat[:dbl]):dbl;", "", "" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:flt],e2:bat[:flt]):flt;", "", "" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:int],e2:bat[:int]):int;", "", "" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:lng],e2:bat[:lng]):lng;", "", "" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:sht],e2:bat[:sht]):sht;", "", "" ] -[ "aggr", "exist", "command aggr.exist(b:bat[:any_2],h:any_1):bit ", "ALGexist;", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:bte], e2:bat[:bte]):bte;", "", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:dbl], e2:bat[:dbl]):dbl;", "", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:flt], e2:bat[:flt]):flt;", "", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:int], e2:bat[:int]):int;", "", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:lng], e2:bat[:lng]):lng;", "", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:sht], e2:bat[:sht]):sht;", "", "" ] +[ "aggr", "exist", "command aggr.exist(b:bat[:any_2], h:any_1):bit ", "ALGexist;", "" ] [ "aggr", "jsonaggr", "command aggr.jsonaggr(val:bat[:dbl]):str ", "JSONgroupStr;", "Aggregate the double values to array." ] [ "aggr", "jsonaggr", "command aggr.jsonaggr(val:bat[:str]):str ", "JSONgroupStr;", "Aggregate the string values to array." ] -[ "aggr", "max", "command aggr.max(b:bat[:any_1],g:bat[:oid],e:bat[:any_2]):bat[:any_1] ", "AGGRmax3;", "" ] +[ "aggr", "max", "command aggr.max(b:bat[:any_1], g:bat[:oid], e:bat[:any_2]):bat[:any_1] ", "AGGRmax3;", "" ] [ "aggr", "max", "command aggr.max(b:bat[:any_2]):any_2 ", "ALGmaxany;", "Return the highest tail value or nil." ] [ "aggr", "median", "function aggr.median(b:bat[:any_1]):any_1;", "", "" ] -[ "aggr", "median", "command aggr.median(b:bat[:any_1],g:bat[:oid],e:bat[:any_2]):bat[:any_1] ", "AGGRmedian3;", "Grouped median aggregate" ] -[ "aggr", "min", "command aggr.min(b:bat[:any_1],g:bat[:oid],e:bat[:any_2]):bat[:any_1] ", "AGGRmin3;", "" ] +[ "aggr", "median", "command aggr.median(b:bat[:any_1], g:bat[:oid], e:bat[:any_2]):bat[:any_1] ", "AGGRmedian3;", "Grouped median aggregate" ] +[ "aggr", "min", "command aggr.min(b:bat[:any_1], g:bat[:oid], e:bat[:any_2]):bat[:any_1] ", "AGGRmin3;", "" ] [ "aggr", "min", "command aggr.min(b:bat[:any_2]):any_2 ", "ALGminany;", "Return the lowest tail value or nil." ] -[ "aggr", "prod", "command aggr.prod(b:bat[:bte],g:bat[:oid],e:bat[:any_1]):bat[:bte] ", "AGGRprod3_bte;", "Grouped tail product on bte" ] -[ "aggr", "prod", "command aggr.prod(b:bat[:dbl],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRprod3_dbl;", "Grouped tail product on dbl" ] -[ "aggr", "prod", "command aggr.prod(b:bat[:flt],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRprod3_dbl;", "Grouped tail product on flt" ] -[ "aggr", "prod", "command aggr.prod(b:bat[:flt],g:bat[:oid],e:bat[:any_1]):bat[:flt] ", "AGGRprod3_flt;", "Grouped tail product on flt" ] -[ "aggr", "prod", "command aggr.prod(b:bat[:bte],g:bat[:oid],e:bat[:any_1]):bat[:int] ", "AGGRprod3_int;", "Grouped tail product on bte" ] -[ "aggr", "prod", "command aggr.prod(b:bat[:int],g:bat[:oid],e:bat[:any_1]):bat[:int] ", "AGGRprod3_int;", "Grouped tail product on int" ] -[ "aggr", "prod", "command aggr.prod(b:bat[:sht],g:bat[:oid],e:bat[:any_1]):bat[:int] ", "AGGRprod3_int;", "Grouped tail product on sht" ] -[ "aggr", "prod", "command aggr.prod(b:bat[:bte],g:bat[:oid],e:bat[:any_1]):bat[:lng] ", "AGGRprod3_lng;", "Grouped tail product on bte" ] -[ "aggr", "prod", "command aggr.prod(b:bat[:int],g:bat[:oid],e:bat[:any_1]):bat[:lng] ", "AGGRprod3_lng;", "Grouped tail product on int" ] -[ "aggr", "prod", "command aggr.prod(b:bat[:lng],g:bat[:oid],e:bat[:any_1]):bat[:lng] ", "AGGRprod3_lng;", "Grouped tail product on lng" ] -[ "aggr", "prod", "command aggr.prod(b:bat[:sht],g:bat[:oid],e:bat[:any_1]):bat[:lng] ", "AGGRprod3_lng;", "Grouped tail product on sht" ] -[ "aggr", "prod", "command aggr.prod(b:bat[:bte],g:bat[:oid],e:bat[:any_1]):bat[:sht] ", "AGGRprod3_sht;", "Grouped tail product on bte" ] -[ "aggr", "prod", "command aggr.prod(b:bat[:sht],g:bat[:oid],e:bat[:any_1]):bat[:sht] ", "AGGRprod3_sht;", "Grouped tail product on sht" ] +[ "aggr", "prod", "command aggr.prod(b:bat[:bte], g:bat[:oid], e:bat[:any_1]):bat[:bte] ", "AGGRprod3_bte;", "Grouped tail product on bte" ] +[ "aggr", "prod", "command aggr.prod(b:bat[:dbl], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRprod3_dbl;", "Grouped tail product on dbl" ] +[ "aggr", "prod", "command aggr.prod(b:bat[:flt], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRprod3_dbl;", "Grouped tail product on flt" ] +[ "aggr", "prod", "command aggr.prod(b:bat[:flt], g:bat[:oid], e:bat[:any_1]):bat[:flt] ", "AGGRprod3_flt;", "Grouped tail product on flt" ] +[ "aggr", "prod", "command aggr.prod(b:bat[:bte], g:bat[:oid], e:bat[:any_1]):bat[:int] ", "AGGRprod3_int;", "Grouped tail product on bte" ] +[ "aggr", "prod", "command aggr.prod(b:bat[:int], g:bat[:oid], e:bat[:any_1]):bat[:int] ", "AGGRprod3_int;", "Grouped tail product on int" ] +[ "aggr", "prod", "command aggr.prod(b:bat[:sht], g:bat[:oid], e:bat[:any_1]):bat[:int] ", "AGGRprod3_int;", "Grouped tail product on sht" ] +[ "aggr", "prod", "command aggr.prod(b:bat[:bte], g:bat[:oid], e:bat[:any_1]):bat[:lng] ", "AGGRprod3_lng;", "Grouped tail product on bte" ] +[ "aggr", "prod", "command aggr.prod(b:bat[:int], g:bat[:oid], e:bat[:any_1]):bat[:lng] ", "AGGRprod3_lng;", "Grouped tail product on int" ] +[ "aggr", "prod", "command aggr.prod(b:bat[:lng], g:bat[:oid], e:bat[:any_1]):bat[:lng] ", "AGGRprod3_lng;", "Grouped tail product on lng" ] +[ "aggr", "prod", "command aggr.prod(b:bat[:sht], g:bat[:oid], e:bat[:any_1]):bat[:lng] ", "AGGRprod3_lng;", "Grouped tail product on sht" ] +[ "aggr", "prod", "command aggr.prod(b:bat[:bte], g:bat[:oid], e:bat[:any_1]):bat[:sht] ", "AGGRprod3_sht;", "Grouped tail product on bte" ] +[ "aggr", "prod", "command aggr.prod(b:bat[:sht], g:bat[:oid], e:bat[:any_1]):bat[:sht] ", "AGGRprod3_sht;", "Grouped tail product on sht" ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:bte]):bte ", "CMDBATprod;", "Calculate aggregate product of B." ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:bte]):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:bte]):int ", "CMDBATprod;", "Calculate aggregate product of B." ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:bte]):lng ", "CMDBATprod;", "Calculate aggregate product of B." ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:bte]):sht ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte],nil_if_empty:bit):bte ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte],nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte],nil_if_empty:bit):int ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte],nil_if_empty:bit):lng ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte],nil_if_empty:bit):sht ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte],s:bat[:oid]):bte ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte],s:bat[:oid]):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte],s:bat[:oid]):int ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte],s:bat[:oid]):lng ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte],s:bat[:oid]):sht ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte],s:bat[:oid],nil_if_empty:bit):bte ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte],s:bat[:oid],nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte],s:bat[:oid],nil_if_empty:bit):int ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte],s:bat[:oid],nil_if_empty:bit):lng ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte],s:bat[:oid],nil_if_empty:bit):sht ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte], nil_if_empty:bit):bte ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte], nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte], nil_if_empty:bit):int ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte], nil_if_empty:bit):lng ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte], nil_if_empty:bit):sht ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte], s:bat[:oid]):bte ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte], s:bat[:oid]):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte], s:bat[:oid]):int ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte], s:bat[:oid]):lng ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte], s:bat[:oid]):sht ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte], s:bat[:oid], nil_if_empty:bit):bte ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte], s:bat[:oid], nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte], s:bat[:oid], nil_if_empty:bit):int ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte], s:bat[:oid], nil_if_empty:bit):lng ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:bte], s:bat[:oid], nil_if_empty:bit):sht ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:dbl]):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:dbl],nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:dbl],s:bat[:oid]):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:dbl],s:bat[:oid],nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:dbl], nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:dbl], s:bat[:oid]):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:dbl], s:bat[:oid], nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:flt]):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:flt]):flt ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:flt],nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:flt],nil_if_empty:bit):flt ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:flt],s:bat[:oid]):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:flt],s:bat[:oid]):flt ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:flt],s:bat[:oid],nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:flt],s:bat[:oid],nil_if_empty:bit):flt ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:flt], nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:flt], nil_if_empty:bit):flt ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:flt], s:bat[:oid]):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:flt], s:bat[:oid]):flt ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:flt], s:bat[:oid], nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:flt], s:bat[:oid], nil_if_empty:bit):flt ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:int]):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:int]):int ", "CMDBATprod;", "Calculate aggregate product of B." ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:int]):lng ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:int],nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:int],nil_if_empty:bit):int ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:int],nil_if_empty:bit):lng ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:int],s:bat[:oid]):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:int],s:bat[:oid]):int ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:int],s:bat[:oid]):lng ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:int],s:bat[:oid],nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:int],s:bat[:oid],nil_if_empty:bit):int ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:int],s:bat[:oid],nil_if_empty:bit):lng ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:int], nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:int], nil_if_empty:bit):int ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:int], nil_if_empty:bit):lng ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:int], s:bat[:oid]):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:int], s:bat[:oid]):int ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:int], s:bat[:oid]):lng ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:int], s:bat[:oid], nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:int], s:bat[:oid], nil_if_empty:bit):int ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:int], s:bat[:oid], nil_if_empty:bit):lng ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:lng]):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:lng]):lng ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:lng],nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:lng],nil_if_empty:bit):lng ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:lng],s:bat[:oid]):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:lng],s:bat[:oid]):lng ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:lng],s:bat[:oid],nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:lng],s:bat[:oid],nil_if_empty:bit):lng ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:lng], nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:lng], nil_if_empty:bit):lng ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:lng], s:bat[:oid]):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:lng], s:bat[:oid]):lng ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:lng], s:bat[:oid], nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:lng], s:bat[:oid], nil_if_empty:bit):lng ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:sht]):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:sht]):int ", "CMDBATprod;", "Calculate aggregate product of B." ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:sht]):lng ", "CMDBATprod;", "Calculate aggregate product of B." ] [ "aggr", "prod", "pattern aggr.prod(b:bat[:sht]):sht ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht],nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht],nil_if_empty:bit):int ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht],nil_if_empty:bit):lng ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht],nil_if_empty:bit):sht ", "CMDBATprod;", "Calculate aggregate product of B." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht],s:bat[:oid]):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht],s:bat[:oid]):int ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht],s:bat[:oid]):lng ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht],s:bat[:oid]):sht ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht],s:bat[:oid],nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht],s:bat[:oid],nil_if_empty:bit):int ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht],s:bat[:oid],nil_if_empty:bit):lng ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht],s:bat[:oid],nil_if_empty:bit):sht ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] -[ "aggr", "quantile", "function aggr.quantile(b:bat[:any_1],q:bat[:dbl]):any_1;", "", "" ] -[ "aggr", "quantile", "command aggr.quantile(b:bat[:any_1],g:bat[:oid],e:bat[:any_2],q:bat[:dbl]):bat[:any_1] ", "AGGRquantile3;", "Grouped quantile aggregate" ] -[ "aggr", "stdev", "command aggr.stdev(b:bat[:bte],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "Grouped tail standard deviation (sample/non-biased) on bte" ] -[ "aggr", "stdev", "command aggr.stdev(b:bat[:dbl],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "Grouped tail standard deviation (sample/non-biased) on dbl" ] -[ "aggr", "stdev", "command aggr.stdev(b:bat[:flt],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "Grouped tail standard deviation (sample/non-biased) on flt" ] -[ "aggr", "stdev", "command aggr.stdev(b:bat[:int],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "Grouped tail standard deviation (sample/non-biased) on int" ] -[ "aggr", "stdev", "command aggr.stdev(b:bat[:lng],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "Grouped tail standard deviation (sample/non-biased) on lng" ] -[ "aggr", "stdev", "command aggr.stdev(b:bat[:sht],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "Grouped tail standard deviation (sample/non-biased) on sht" ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht], nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht], nil_if_empty:bit):int ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht], nil_if_empty:bit):lng ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht], nil_if_empty:bit):sht ", "CMDBATprod;", "Calculate aggregate product of B." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht], s:bat[:oid]):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht], s:bat[:oid]):int ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht], s:bat[:oid]):lng ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht], s:bat[:oid]):sht ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht], s:bat[:oid], nil_if_empty:bit):dbl ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht], s:bat[:oid], nil_if_empty:bit):int ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht], s:bat[:oid], nil_if_empty:bit):lng ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "prod", "pattern aggr.prod(b:bat[:sht], s:bat[:oid], nil_if_empty:bit):sht ", "CMDBATprod;", "Calculate aggregate product of B with candidate list." ] +[ "aggr", "quantile", "function aggr.quantile(b:bat[:any_1], q:bat[:dbl]):any_1;", "", "" ] +[ "aggr", "quantile", "command aggr.quantile(b:bat[:any_1], g:bat[:oid], e:bat[:any_2], q:bat[:dbl]):bat[:any_1] ", "AGGRquantile3;", "Grouped quantile aggregate" ] +[ "aggr", "stdev", "command aggr.stdev(b:bat[:bte], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "Grouped tail standard deviation (sample/non-biased) on bte" ] +[ "aggr", "stdev", "command aggr.stdev(b:bat[:dbl], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "Grouped tail standard deviation (sample/non-biased) on dbl" ] +[ "aggr", "stdev", "command aggr.stdev(b:bat[:flt], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "Grouped tail standard deviation (sample/non-biased) on flt" ] +[ "aggr", "stdev", "command aggr.stdev(b:bat[:int], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "Grouped tail standard deviation (sample/non-biased) on int" ] +[ "aggr", "stdev", "command aggr.stdev(b:bat[:lng], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "Grouped tail standard deviation (sample/non-biased) on lng" ] +[ "aggr", "stdev", "command aggr.stdev(b:bat[:sht], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "Grouped tail standard deviation (sample/non-biased) on sht" ] [ "aggr", "stdev", "command aggr.stdev(b:bat[:any_2]):dbl ", "ALGstdev;", "Gives the standard deviation of all tail values" ] -[ "aggr", "stdevp", "command aggr.stdevp(b:bat[:bte],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "Grouped tail standard deviation (population/biased) on bte" ] -[ "aggr", "stdevp", "command aggr.stdevp(b:bat[:dbl],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "Grouped tail standard deviation (population/biased) on dbl" ] -[ "aggr", "stdevp", "command aggr.stdevp(b:bat[:flt],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "Grouped tail standard deviation (population/biased) on flt" ] -[ "aggr", "stdevp", "command aggr.stdevp(b:bat[:int],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "Grouped tail standard deviation (population/biased) on int" ] -[ "aggr", "stdevp", "command aggr.stdevp(b:bat[:lng],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "Grouped tail standard deviation (population/biased) on lng" ] -[ "aggr", "stdevp", "command aggr.stdevp(b:bat[:sht],g:bat[:oid],e:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "Grouped tail standard deviation (population/biased) on sht" ] +[ "aggr", "stdevp", "command aggr.stdevp(b:bat[:bte], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "Grouped tail standard deviation (population/biased) on bte" ] +[ "aggr", "stdevp", "command aggr.stdevp(b:bat[:dbl], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "Grouped tail standard deviation (population/biased) on dbl" ] +[ "aggr", "stdevp", "command aggr.stdevp(b:bat[:flt], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "Grouped tail standard deviation (population/biased) on flt" ] +[ "aggr", "stdevp", "command aggr.stdevp(b:bat[:int], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "Grouped tail standard deviation (population/biased) on int" ] +[ "aggr", "stdevp", "command aggr.stdevp(b:bat[:lng], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "Grouped tail standard deviation (population/biased) on lng" ] +[ "aggr", "stdevp", "command aggr.stdevp(b:bat[:sht], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "Grouped tail standard deviation (population/biased) on sht" ] [ "aggr", "stdevp", "command aggr.stdevp(b:bat[:any_2]):dbl ", "ALGstdevp;", "Gives the standard deviation of all tail values" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:bte],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1_dbl;", "Grouped average aggregate" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1_dbl;", "Grouped average aggregate" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:flt],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1_dbl;", "Grouped average aggregate" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:int],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1_dbl;", "Grouped average aggregate" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:lng],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1_dbl;", "Grouped average aggregate" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:sht],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1_dbl;", "Grouped average aggregate" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:bte],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1cand_dbl;", "Grouped average aggregate with candidates list" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1cand_dbl;", "Grouped average aggregate with candidates list" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:flt],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1cand_dbl;", "Grouped average aggregate with candidates list" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:int],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1cand_dbl;", "Grouped average aggregate with candidates list" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:lng],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1cand_dbl;", "Grouped average aggregate with candidates list" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:sht],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1cand_dbl;", "Grouped average aggregate with candidates list" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:bte],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRsubavg2_dbl;", "Grouped average aggregate, also returns count" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRsubavg2_dbl;", "Grouped average aggregate, also returns count" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:flt],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRsubavg2_dbl;", "Grouped average aggregate, also returns count" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:int],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRsubavg2_dbl;", "Grouped average aggregate, also returns count" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:lng],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRsubavg2_dbl;", "Grouped average aggregate, also returns count" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:sht],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRsubavg2_dbl;", "Grouped average aggregate, also returns count" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:bte],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with candidates list, also returns count" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with candidates list, also returns count" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:flt],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with candidates list, also returns count" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:int],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with candidates list, also returns count" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:lng],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with candidates list, also returns count" ] -[ "aggr", "subavg", "command aggr.subavg(b:bat[:sht],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with candidates list, also returns count" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:bte],e2:bat[:bte],g:bat[:oid],e:bat[:any_2],f:bit):bat[:bte];", "", "" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:dbl],e2:bat[:dbl],g:bat[:oid],e:bat[:any_2],f:bit):bat[:dbl];", "", "" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:flt],e2:bat[:flt],g:bat[:oid],e:bat[:any_2],f:bit):bat[:flt];", "", "" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:int],e2:bat[:int],g:bat[:oid],e:bat[:any_2],f:bit):bat[:int];", "", "" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:lng],e2:bat[:lng],g:bat[:oid],e:bat[:any_2],f:bit):bat[:lng];", "", "" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:sht],e2:bat[:sht],g:bat[:oid],e:bat[:any_2],f:bit):bat[:sht];", "", "" ] -[ "aggr", "subcount", "command aggr.subcount(b:bat[:any_1],g:bat[:oid],e:bat[:any_2],skip_nils:bit):bat[:lng] ", "AGGRsubcount;", "Grouped count aggregate" ] -[ "aggr", "subcount", "command aggr.subcount(b:bat[:any_1],g:bat[:oid],e:bat[:any_2],s:bat[:oid],skip_nils:bit):bat[:lng] ", "AGGRsubcountcand;", "Grouped count aggregate with candidates list" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:bte],e2:bat[:bte],g:bat[:oid],e:bat[:any_2],f:bit):bat[:bte];", "", "" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:dbl],e2:bat[:dbl],g:bat[:oid],e:bat[:any_2],f:bit):bat[:dbl];", "", "" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:flt],e2:bat[:flt],g:bat[:oid],e:bat[:any_2],f:bit):bat[:flt];", "", "" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:int],e2:bat[:int],g:bat[:oid],e:bat[:any_2],f:bit):bat[:int];", "", "" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:lng],e2:bat[:lng],g:bat[:oid],e:bat[:any_2],f:bit):bat[:lng];", "", "" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:sht],e2:bat[:sht],g:bat[:oid],e:bat[:any_2],f:bit):bat[:sht];", "", "" ] -[ "aggr", "subjsonaggr", "command aggr.subjsonaggr(val:bat[:dbl],g:bat[:oid],e:bat[:any_1],skip_nils:bit):bat[:str] ", "JSONsubjson;", "Grouped aggregation of values." ] -[ "aggr", "subjsonaggr", "command aggr.subjsonaggr(val:bat[:str],g:bat[:oid],e:bat[:any_1],skip_nils:bit):bat[:str] ", "JSONsubjson;", "Grouped aggregation of values." ] -[ "aggr", "subjsonaggr", "command aggr.subjsonaggr(val:bat[:dbl],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit):bat[:str] ", "JSONsubjsoncand;", "Grouped aggregation of values with candidates list." ] -[ "aggr", "subjsonaggr", "command aggr.subjsonaggr(val:bat[:str],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit):bat[:str] ", "JSONsubjsoncand;", "Grouped aggregation of values with candidates list." ] -[ "aggr", "submax", "command aggr.submax(b:bat[:any_1],g:bat[:oid],e:bat[:any_2],skip_nils:bit):bat[:oid] ", "AGGRsubmax;", "Grouped maximum aggregate" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list