Changeset: a9d818fa4c30 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a9d818fa4c30 Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 Branch: pushcands Log Message:
Approved output diffs (truncated from 19901 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 @@ -4,705 +4,707 @@ stdout of test 'MAL-signatures` in direc % .%1, .%1, .%1, .%1, .%1 # table_name % module, function, signature, address, comment # name % clob, clob, clob, clob, clob # type -% 12, 28, 313, 42, 0 # length -[ "aggr", "all", "command aggr.all(X_0:bat[:any_1]):any_1 ", "SQLall;", "" ] -[ "aggr", "allnotequal", "pattern aggr.allnotequal(X_0:bat[:any_1], X_1:bat[:any_1]):bit ", "SQLallnotequal;", "" ] +% 12, 28, 313, 42, 860 # length +[ "aggr", "all", "command aggr.all(X_0:bat[:any_1]):any_1 ", "SQLall;", "if all values in b are equal return this, else nil" ] +[ "aggr", "allnotequal", "pattern aggr.allnotequal(X_0:bat[:any_1], X_1:bat[:any_1]):bit ", "SQLallnotequal;", "if all values in r are not equal to l return true, else if r has nil nil else false" ] [ "aggr", "anyequal", "pattern aggr.anyequal(X_0:any_1, X_1:any_1):bit ", "CMDvarEQ;", "" ] -[ "aggr", "anyequal", "pattern aggr.anyequal(X_0:bat[:any_1], X_1:bat[:any_1]):bit ", "SQLanyequal;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] ", "AGGRavg14_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] ", "AGGRavg14_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] ", "AGGRavg14_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] ", "AGGRavg14_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] ", "AGGRavg14_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] ", "AGGRavg14_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) ", "AGGRavg23_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) ", "AGGRavg23_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) ", "AGGRavg23_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) ", "AGGRavg23_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) ", "AGGRavg23_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) ", "AGGRavg23_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) ", "AGGRavg24_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) ", "AGGRavg24_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) ", "AGGRavg24_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) ", "AGGRavg24_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) ", "AGGRavg24_dbl;", "" ] -[ "aggr", "avg", "command aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) ", "AGGRavg24_dbl;", "" ] -[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bit) (X_3:bte, X_4:lng, X_5:lng) ", "CMDBATavg3;", "" ] -[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bit) (X_3:int, X_4:lng, X_5:lng) ", "CMDBATavg3;", "" ] -[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bit) (X_3:lng, X_4:lng, X_5:lng) ", "CMDBATavg3;", "" ] -[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bit) (X_3:sht, X_4:lng, X_5:lng) ", "CMDBATavg3;", "" ] -[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:bte], X_1:bat[:lng], X_2:bat[:lng]):bte ", "CMDBATavg3comb;", "" ] -[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:int], X_1:bat[:lng], X_2:bat[:lng]):int ", "CMDBATavg3comb;", "" ] -[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:lng], X_1:bat[:lng], X_2:bat[:lng]):lng ", "CMDBATavg3comb;", "" ] -[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:sht], X_1:bat[:lng], X_2:bat[:lng]):sht ", "CMDBATavg3comb;", "" ] -[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:any_2]):dbl ", "CMDcalcavg;", "" ] -[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:any_2], X_1:int):dbl ", "CMDcalcavg;", "" ] -[ "aggr", "cardinality", "command aggr.cardinality(X_0:bat[:any_2]):lng ", "ALGcard;", "" ] -[ "aggr", "corr", "command aggr.corr(X_0:bat[:bte], X_1:bat[:bte], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "" ] -[ "aggr", "corr", "command aggr.corr(X_0:bat[:dbl], X_1:bat[:dbl], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "" ] -[ "aggr", "corr", "command aggr.corr(X_0:bat[:flt], X_1:bat[:flt], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "" ] -[ "aggr", "corr", "command aggr.corr(X_0:bat[:int], X_1:bat[:int], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "" ] -[ "aggr", "corr", "command aggr.corr(X_0:bat[:lng], X_1:bat[:lng], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "" ] -[ "aggr", "corr", "command aggr.corr(X_0:bat[:sht], X_1:bat[:sht], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "" ] -[ "aggr", "corr", "command aggr.corr(X_0:bat[:any_2], X_1:bat[:any_2], X_2:bat[:oid], X_3:bat[:oid]):dbl ", "ALGcorr2;", "" ] -[ "aggr", "corr", "command aggr.corr(X_0:bat[:any_2], X_1:bat[:any_2]):dbl ", "ALGcorr;", "" ] +[ "aggr", "anyequal", "pattern aggr.anyequal(X_0:bat[:any_1], X_1:bat[:any_1]):bit ", "SQLanyequal;", "if any value in r is equal to l return true, else if r has nil nil else false" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on bte" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on dbl" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on flt" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on int" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on lng" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on sht" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] ", "AGGRavg14_dbl;", "Grouped tail average on bte" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] ", "AGGRavg14_dbl;", "Grouped tail average on dbl" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] ", "AGGRavg14_dbl;", "Grouped tail average on flt" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] ", "AGGRavg14_dbl;", "Grouped tail average on int" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] ", "AGGRavg14_dbl;", "Grouped tail average on lng" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] ", "AGGRavg14_dbl;", "Grouped tail average on sht" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on bte, also returns count" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on dbl, also returns count" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on flt, also returns count" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on int, also returns count" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on lng, also returns count" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on sht, also returns count" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) ", "AGGRavg24_dbl;", "Grouped tail average on bte, also returns count" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) ", "AGGRavg24_dbl;", "Grouped tail average on dbl, also returns count" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) ", "AGGRavg24_dbl;", "Grouped tail average on flt, also returns count" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) ", "AGGRavg24_dbl;", "Grouped tail average on int, also returns count" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) ", "AGGRavg24_dbl;", "Grouped tail average on lng, also returns count" ] +[ "aggr", "avg", "command aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) ", "AGGRavg24_dbl;", "Grouped tail average on sht, also returns count" ] +[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bit) (X_3:bte, X_4:lng, X_5:lng) ", "CMDBATavg3;", "Calculate aggregate average of B." ] +[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bit) (X_3:int, X_4:lng, X_5:lng) ", "CMDBATavg3;", "Calculate aggregate average of B." ] +[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bit) (X_3:lng, X_4:lng, X_5:lng) ", "CMDBATavg3;", "Calculate aggregate average of B." ] +[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bit) (X_3:sht, X_4:lng, X_5:lng) ", "CMDBATavg3;", "Calculate aggregate average of B." ] +[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:bte], X_1:bat[:lng], X_2:bat[:lng]):bte ", "CMDBATavg3comb;", "Average aggregation combiner." ] +[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:int], X_1:bat[:lng], X_2:bat[:lng]):int ", "CMDBATavg3comb;", "Average aggregation combiner." ] +[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:lng], X_1:bat[:lng], X_2:bat[:lng]):lng ", "CMDBATavg3comb;", "Average aggregation combiner." ] +[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:sht], X_1:bat[:lng], X_2:bat[:lng]):sht ", "CMDBATavg3comb;", "Average aggregation combiner." ] +[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:any_2]):dbl ", "CMDcalcavg;", "Gives the avg of all tail values" ] +[ "aggr", "avg", "pattern aggr.avg(X_0:bat[:any_2], X_1:int):dbl ", "CMDcalcavg;", "Gives the avg of all tail values" ] +[ "aggr", "cardinality", "command aggr.cardinality(X_0:bat[:any_2]):lng ", "ALGcard;", "Return the cardinality of the BAT tail values." ] +[ "aggr", "corr", "command aggr.corr(X_0:bat[:bte], X_1:bat[:bte], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation aggregate" ] +[ "aggr", "corr", "command aggr.corr(X_0:bat[:dbl], X_1:bat[:dbl], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation aggregate" ] +[ "aggr", "corr", "command aggr.corr(X_0:bat[:flt], X_1:bat[:flt], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation aggregate" ] +[ "aggr", "corr", "command aggr.corr(X_0:bat[:int], X_1:bat[:int], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation aggregate" ] +[ "aggr", "corr", "command aggr.corr(X_0:bat[:lng], X_1:bat[:lng], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation aggregate" ] +[ "aggr", "corr", "command aggr.corr(X_0:bat[:sht], X_1:bat[:sht], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation aggregate" ] +[ "aggr", "corr", "command aggr.corr(X_0:bat[:any_2], X_1:bat[:any_2], X_2:bat[:oid], X_3:bat[:oid]):dbl ", "ALGcorr2;", "Gives the correlation of all tail values" ] +[ "aggr", "corr", "command aggr.corr(X_0:bat[:any_2], X_1:bat[:any_2]):dbl ", "ALGcorr;", "Gives the correlation of all tail values" ] [ "aggr", "count", "command aggr.count(X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:any_2], X_3:bit):bat[:lng] ", "AGGRcount3;", "" ] -[ "aggr", "count", "command aggr.count(X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:any_2]):bat[:lng] ", "AGGRcount3nils;", "" ] -[ "aggr", "count", "command aggr.count(X_0:bat[:any], X_1:bat[:oid]):lng ", "ALGcountCND_bat;", "" ] -[ "aggr", "count", "command aggr.count(X_0:bat[:any], X_1:bat[:oid], X_2:bit):lng ", "ALGcountCND_nil;", "" ] -[ "aggr", "count", "command aggr.count(X_0:bat[:any]):lng ", "ALGcount_bat;", "" ] -[ "aggr", "count", "command aggr.count(X_0:bat[:any], X_1:bit):lng ", "ALGcount_nil;", "" ] +[ "aggr", "count", "command aggr.count(X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:any_2]):bat[:lng] ", "AGGRcount3nils;", "Grouped count" ] +[ "aggr", "count", "command aggr.count(X_0:bat[:any], X_1:bat[:oid]):lng ", "ALGcountCND_bat;", "Return the current size (in number of elements) in a BAT." ] +[ "aggr", "count", "command aggr.count(X_0:bat[:any], X_1:bat[:oid], X_2:bit):lng ", "ALGcountCND_nil;", "Return the number of elements currently in a BAT ignores\nBUNs with nil-tail iff ignore_nils==TRUE." ] +[ "aggr", "count", "command aggr.count(X_0:bat[:any]):lng ", "ALGcount_bat;", "Return the current size (in number of elements) in a BAT." ] +[ "aggr", "count", "command aggr.count(X_0:bat[:any], X_1:bit):lng ", "ALGcount_nil;", "Return the number of elements currently in a BAT ignores\nBUNs with nil-tail iff ignore_nils==TRUE." ] [ "aggr", "count_no_nil", "command aggr.count_no_nil(X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:any_2]):bat[:lng] ", "AGGRcount3nonils;", "" ] -[ "aggr", "count_no_nil", "command aggr.count_no_nil(X_0:bat[:any_2], X_1:bat[:oid]):lng ", "ALGcountCND_no_nil;", "" ] -[ "aggr", "count_no_nil", "command aggr.count_no_nil(X_0:bat[:any_2]):lng ", "ALGcount_no_nil;", "" ] -[ "aggr", "covariance", "command aggr.covariance(X_0:bat[:bte], X_1:bat[:bte], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;", "" ] -[ "aggr", "covariance", "command aggr.covariance(X_0:bat[:dbl], X_1:bat[:dbl], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;", "" ] -[ "aggr", "covariance", "command aggr.covariance(X_0:bat[:flt], X_1:bat[:flt], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;", "" ] -[ "aggr", "covariance", "command aggr.covariance(X_0:bat[:int], X_1:bat[:int], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;", "" ] -[ "aggr", "covariance", "command aggr.covariance(X_0:bat[:lng], X_1:bat[:lng], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;", "" ] -[ "aggr", "covariance", "command aggr.covariance(X_0:bat[:sht], X_1:bat[:sht], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;", "" ] -[ "aggr", "covariance", "command aggr.covariance(X_0:bat[:any_2], X_1:bat[:any_2], X_2:bat[:oid], X_3:bat[:oid]):dbl ", "ALGcovariance2;", "" ] -[ "aggr", "covariance", "command aggr.covariance(X_0:bat[:any_2], X_1:bat[:any_2]):dbl ", "ALGcovariance;", "" ] -[ "aggr", "covariancep", "command aggr.covariancep(X_0:bat[:bte], X_1:bat[:bte], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;", "" ] -[ "aggr", "covariancep", "command aggr.covariancep(X_0:bat[:dbl], X_1:bat[:dbl], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;", "" ] -[ "aggr", "covariancep", "command aggr.covariancep(X_0:bat[:flt], X_1:bat[:flt], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;", "" ] -[ "aggr", "covariancep", "command aggr.covariancep(X_0:bat[:int], X_1:bat[:int], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;", "" ] -[ "aggr", "covariancep", "command aggr.covariancep(X_0:bat[:lng], X_1:bat[:lng], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;", "" ] -[ "aggr", "covariancep", "command aggr.covariancep(X_0:bat[:sht], X_1:bat[:sht], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;", "" ] -[ "aggr", "covariancep", "command aggr.covariancep(X_0:bat[:any_2], X_1:bat[:any_2], X_2:bat[:oid], X_3:bat[:oid]):dbl ", "ALGcovariancep2;", "" ] -[ "aggr", "covariancep", "command aggr.covariancep(X_0:bat[:any_2], X_1:bat[:any_2]):dbl ", "ALGcovariancep;", "" ] +[ "aggr", "count_no_nil", "command aggr.count_no_nil(X_0:bat[:any_2], X_1:bat[:oid]):lng ", "ALGcountCND_no_nil;", "Return the number of elements currently\nin a BAT ignoring BUNs with nil-tail" ] +[ "aggr", "count_no_nil", "command aggr.count_no_nil(X_0:bat[:any_2]):lng ", "ALGcount_no_nil;", "Return the number of elements currently\nin a BAT ignoring BUNs with nil-tail" ] +[ "aggr", "covariance", "command aggr.covariance(X_0:bat[:bte], X_1:bat[:bte], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;", "Covariance sample aggregate" ] +[ "aggr", "covariance", "command aggr.covariance(X_0:bat[:dbl], X_1:bat[:dbl], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;", "Covariance sample aggregate" ] +[ "aggr", "covariance", "command aggr.covariance(X_0:bat[:flt], X_1:bat[:flt], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;", "Covariance sample aggregate" ] +[ "aggr", "covariance", "command aggr.covariance(X_0:bat[:int], X_1:bat[:int], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;", "Covariance sample aggregate" ] +[ "aggr", "covariance", "command aggr.covariance(X_0:bat[:lng], X_1:bat[:lng], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;", "Covariance sample aggregate" ] +[ "aggr", "covariance", "command aggr.covariance(X_0:bat[:sht], X_1:bat[:sht], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;", "Covariance sample aggregate" ] +[ "aggr", "covariance", "command aggr.covariance(X_0:bat[:any_2], X_1:bat[:any_2], X_2:bat[:oid], X_3:bat[:oid]):dbl ", "ALGcovariance2;", "Gives the covariance of all tail values" ] +[ "aggr", "covariance", "command aggr.covariance(X_0:bat[:any_2], X_1:bat[:any_2]):dbl ", "ALGcovariance;", "Gives the covariance of all tail values" ] +[ "aggr", "covariancep", "command aggr.covariancep(X_0:bat[:bte], X_1:bat[:bte], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;", "Covariance population aggregate" ] +[ "aggr", "covariancep", "command aggr.covariancep(X_0:bat[:dbl], X_1:bat[:dbl], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;", "Covariance population aggregate" ] +[ "aggr", "covariancep", "command aggr.covariancep(X_0:bat[:flt], X_1:bat[:flt], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;", "Covariance population aggregate" ] +[ "aggr", "covariancep", "command aggr.covariancep(X_0:bat[:int], X_1:bat[:int], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;", "Covariance population aggregate" ] +[ "aggr", "covariancep", "command aggr.covariancep(X_0:bat[:lng], X_1:bat[:lng], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;", "Covariance population aggregate" ] +[ "aggr", "covariancep", "command aggr.covariancep(X_0:bat[:sht], X_1:bat[:sht], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;", "Covariance population aggregate" ] +[ "aggr", "covariancep", "command aggr.covariancep(X_0:bat[:any_2], X_1:bat[:any_2], X_2:bat[:oid], X_3:bat[:oid]):dbl ", "ALGcovariancep2;", "Gives the covariance of all tail values" ] +[ "aggr", "covariancep", "command aggr.covariancep(X_0:bat[:any_2], X_1:bat[:any_2]):dbl ", "ALGcovariancep;", "Gives the covariance of all tail values" ] [ "aggr", "exist", "command aggr.exist(X_0:bat[:any_2], X_1:any_1):bit ", "ALGexist;", "" ] [ "aggr", "exist", "pattern aggr.exist(X_0:any_1):bit ", "SQLexist;", "" ] -[ "aggr", "jsonaggr", "command aggr.jsonaggr(X_0:bat[:dbl]):str ", "JSONgroupStr;", "" ] -[ "aggr", "jsonaggr", "command aggr.jsonaggr(X_0:bat[:str]):str ", "JSONgroupStr;", "" ] +[ "aggr", "jsonaggr", "command aggr.jsonaggr(X_0:bat[:dbl]):str ", "JSONgroupStr;", "Aggregate the double values to array." ] +[ "aggr", "jsonaggr", "command aggr.jsonaggr(X_0:bat[:str]):str ", "JSONgroupStr;", "Aggregate the string values to array." ] [ "aggr", "max", "command aggr.max(X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:any_2]):bat[:any_1] ", "AGGRmax3;", "" ] -[ "aggr", "max", "command aggr.max(X_0:bat[:any_2], X_1:bat[:oid]):any_2 ", "ALGmaxany2;", "" ] -[ "aggr", "max", "command aggr.max(X_0:bat[:any_2], X_1:bit, X_2:bat[:oid]):any_2 ", "ALGmaxany2_skipnil;", "" ] -[ "aggr", "max", "command aggr.max(X_0:bat[:any_2]):any_2 ", "ALGmaxany;", "" ] -[ "aggr", "max", "command aggr.max(X_0:bat[:any_2], X_1:bit):any_2 ", "ALGmaxany_skipnil;", "" ] -[ "aggr", "median", "command aggr.median(X_0:bat[:any_1]):any_1 ", "AGGRmedian;", "" ] -[ "aggr", "median_avg", "command aggr.median_avg(X_0:bat[:any_1]):dbl ", "AGGRmedian_avg;", "" ] +[ "aggr", "max", "command aggr.max(X_0:bat[:any_2], X_1:bat[:oid]):any_2 ", "ALGmaxany2;", "Return the highest tail value or nil." ] +[ "aggr", "max", "command aggr.max(X_0:bat[:any_2], X_1:bit, X_2:bat[:oid]):any_2 ", "ALGmaxany2_skipnil;", "Return the highest tail value or nil." ] +[ "aggr", "max", "command aggr.max(X_0:bat[:any_2]):any_2 ", "ALGmaxany;", "Return the highest tail value or nil." ] +[ "aggr", "max", "command aggr.max(X_0:bat[:any_2], X_1:bit):any_2 ", "ALGmaxany_skipnil;", "Return the highest tail value or nil." ] +[ "aggr", "median", "command aggr.median(X_0:bat[:any_1]):any_1 ", "AGGRmedian;", "Median aggregate" ] +[ "aggr", "median_avg", "command aggr.median_avg(X_0:bat[:any_1]):dbl ", "AGGRmedian_avg;", "Median aggregate" ] [ "aggr", "min", "command aggr.min(X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:any_2]):bat[:any_1] ", "AGGRmin3;", "" ] -[ "aggr", "min", "command aggr.min(X_0:bat[:any_2], X_1:bat[:oid]):any_2 ", "ALGminany2;", "" ] -[ "aggr", "min", "command aggr.min(X_0:bat[:any_2], X_1:bit, X_2:bat[:oid]):any_2 ", "ALGminany2_skipnil;", "" ] -[ "aggr", "min", "command aggr.min(X_0:bat[:any_2]):any_2 ", "ALGminany;", "" ] -[ "aggr", "min", "command aggr.min(X_0:bat[:any_2], X_1:bit):any_2 ", "ALGminany_skipnil;", "" ] +[ "aggr", "min", "command aggr.min(X_0:bat[:any_2], X_1:bat[:oid]):any_2 ", "ALGminany2;", "Return the lowest tail value or nil." ] +[ "aggr", "min", "command aggr.min(X_0:bat[:any_2], X_1:bit, X_2:bat[:oid]):any_2 ", "ALGminany2_skipnil;", "Return the lowest tail value or nil." ] +[ "aggr", "min", "command aggr.min(X_0:bat[:any_2]):any_2 ", "ALGminany;", "Return the lowest tail value or nil." ] +[ "aggr", "min", "command aggr.min(X_0:bat[:any_2], X_1:bit):any_2 ", "ALGminany_skipnil;", "Return the lowest tail value or nil." ] [ "aggr", "not_anyequal", "pattern aggr.not_anyequal(X_0:any_1, X_1:any_1):bit ", "CMDvarNE;", "" ] [ "aggr", "not_exist", "pattern aggr.not_exist(X_0:any_1):bit ", "SQLnot_exist;", "" ] -[ "aggr", "not_unique", "command aggr.not_unique(X_0:bat[:oid]):bit ", "not_unique;", "" ] -[ "aggr", "null", "command aggr.null(X_0:bat[:any_1]):bit ", "SQLnil;", "" ] -[ "aggr", "prod", "command aggr.prod(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]):bat[:bte] ", "AGGRprod3_bte;", "" ] -[ "aggr", "prod", "command aggr.prod(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRprod3_dbl;", "" ] -[ "aggr", "prod", "command aggr.prod(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRprod3_dbl;", "" ] -[ "aggr", "prod", "command aggr.prod(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1]):bat[:flt] ", "AGGRprod3_flt;", "" ] -[ "aggr", "prod", "command aggr.prod(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]):bat[:int] ", "AGGRprod3_int;", "" ] -[ "aggr", "prod", "command aggr.prod(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1]):bat[:int] ", "AGGRprod3_int;", "" ] -[ "aggr", "prod", "command aggr.prod(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1]):bat[:int] ", "AGGRprod3_int;", "" ] -[ "aggr", "prod", "command aggr.prod(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]):bat[:lng] ", "AGGRprod3_lng;", "" ] -[ "aggr", "prod", "command aggr.prod(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1]):bat[:lng] ", "AGGRprod3_lng;", "" ] -[ "aggr", "prod", "command aggr.prod(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1]):bat[:lng] ", "AGGRprod3_lng;", "" ] -[ "aggr", "prod", "command aggr.prod(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1]):bat[:lng] ", "AGGRprod3_lng;", "" ] -[ "aggr", "prod", "command aggr.prod(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]):bat[:sht] ", "AGGRprod3_sht;", "" ] -[ "aggr", "prod", "command aggr.prod(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1]):bat[:sht] ", "AGGRprod3_sht;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte]):bte ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte]):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte]):int ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte]):lng ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte]):sht ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte], X_1:bat[:oid]):bte ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte], X_1:bat[:oid]):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte], X_1:bat[:oid]):int ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte], X_1:bat[:oid]):lng ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte], X_1:bat[:oid]):sht ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte], X_1:bat[:oid], X_2:bit):bte ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte], X_1:bat[:oid], X_2:bit):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte], X_1:bat[:oid], X_2:bit):int ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte], X_1:bat[:oid], X_2:bit):lng ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte], X_1:bat[:oid], X_2:bit):sht ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte], X_1:bit):bte ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte], X_1:bit):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte], X_1:bit):int ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte], X_1:bit):lng ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:bte], X_1:bit):sht ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:dbl]):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:dbl], X_1:bat[:oid]):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:dbl], X_1:bat[:oid], X_2:bit):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:dbl], X_1:bit):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:flt]):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:flt]):flt ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:flt], X_1:bat[:oid]):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:flt], X_1:bat[:oid]):flt ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:flt], X_1:bat[:oid], X_2:bit):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:flt], X_1:bat[:oid], X_2:bit):flt ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:flt], X_1:bit):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:flt], X_1:bit):flt ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:int]):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:int]):int ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:int]):lng ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:int], X_1:bat[:oid]):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:int], X_1:bat[:oid]):int ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:int], X_1:bat[:oid]):lng ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:int], X_1:bat[:oid], X_2:bit):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:int], X_1:bat[:oid], X_2:bit):int ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:int], X_1:bat[:oid], X_2:bit):lng ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:int], X_1:bit):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:int], X_1:bit):int ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:int], X_1:bit):lng ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:lng]):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:lng]):lng ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:lng], X_1:bat[:oid]):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:lng], X_1:bat[:oid]):lng ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:lng], X_1:bat[:oid], X_2:bit):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:lng], X_1:bat[:oid], X_2:bit):lng ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:lng], X_1:bit):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:lng], X_1:bit):lng ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:sht]):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:sht]):int ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:sht]):lng ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:sht]):sht ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:sht], X_1:bat[:oid]):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:sht], X_1:bat[:oid]):int ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:sht], X_1:bat[:oid]):lng ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:sht], X_1:bat[:oid]):sht ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:sht], X_1:bat[:oid], X_2:bit):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:sht], X_1:bat[:oid], X_2:bit):int ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:sht], X_1:bat[:oid], X_2:bit):lng ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:sht], X_1:bat[:oid], X_2:bit):sht ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:sht], X_1:bit):dbl ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:sht], X_1:bit):int ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:sht], X_1:bit):lng ", "CMDBATprod;", "" ] -[ "aggr", "prod", "pattern aggr.prod(X_0:bat[:sht], X_1:bit):sht ", "CMDBATprod;", "" ] -[ "aggr", "quantile", "command aggr.quantile(X_0:bat[:any_1], X_1:bat[:dbl]):any_1 ", "AGGRquantile;", "" ] -[ "aggr", "quantile_avg", "command aggr.quantile_avg(X_0:bat[:any_1], X_1:bat[:dbl]):dbl ", "AGGRquantile_avg;", "" ] -[ "aggr", "stdev", "command aggr.stdev(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "" ] -[ "aggr", "stdev", "command aggr.stdev(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "" ] -[ "aggr", "stdev", "command aggr.stdev(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "" ] -[ "aggr", "stdev", "command aggr.stdev(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "" ] -[ "aggr", "stdev", "command aggr.stdev(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "" ] -[ "aggr", "stdev", "command aggr.stdev(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRstdev3_dbl;", "" ] -[ "aggr", "stdev", "command aggr.stdev(X_0:bat[:any_2], X_1:bat[:oid]):dbl ", "ALGstdev2;", "" ] -[ "aggr", "stdev", "command aggr.stdev(X_0:bat[:any_2]):dbl ", "ALGstdev;", "" ] -[ "aggr", "stdevp", "command aggr.stdevp(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "" ] -[ "aggr", "stdevp", "command aggr.stdevp(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "" ] -[ "aggr", "stdevp", "command aggr.stdevp(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "" ] -[ "aggr", "stdevp", "command aggr.stdevp(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "" ] -[ "aggr", "stdevp", "command aggr.stdevp(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "" ] -[ "aggr", "stdevp", "command aggr.stdevp(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] ", "AGGRstdevp3_dbl;", "" ] -[ "aggr", "stdevp", "command aggr.stdevp(X_0:bat[:any_2], X_1:bat[:oid]):dbl ", "ALGstdevp2;", "" ] -[ "aggr", "stdevp", "command aggr.stdevp(X_0:bat[:any_2]):dbl ", "ALGstdevp;", "" ] -[ "aggr", "str_group_concat", "command aggr.str_group_concat(X_0:bat[:str], X_1:bat[:oid], X_2:bat[:any_1]):bat[:str] ", "AGGRstr_group_concat;", "" ] -[ "aggr", "str_group_concat", "command aggr.str_group_concat(X_0:bat[:str], X_1:bat[:str], X_2:bat[:oid], X_3:bat[:any_1]):bat[:str] ", "AGGRstr_group_concat_sep;", "" ] -[ "aggr", "str_group_concat", "pattern aggr.str_group_concat(X_0:bat[:str]):str ", "CMDBATstr_group_concat;", "" ] -[ "aggr", "str_group_concat", "pattern aggr.str_group_concat(X_0:bat[:str], X_1:bat[:oid]):str ", "CMDBATstr_group_concat;", "" ] -[ "aggr", "str_group_concat", "pattern aggr.str_group_concat(X_0:bat[:str], X_1:bat[:oid], X_2:bit):str ", "CMDBATstr_group_concat;", "" ] -[ "aggr", "str_group_concat", "pattern aggr.str_group_concat(X_0:bat[:str], X_1:bat[:str]):str ", "CMDBATstr_group_concat;", "" ] -[ "aggr", "str_group_concat", "pattern aggr.str_group_concat(X_0:bat[:str], X_1:bat[:str], X_2:bat[:oid]):str ", "CMDBATstr_group_concat;", "" ] -[ "aggr", "str_group_concat", "pattern aggr.str_group_concat(X_0:bat[:str], X_1:bat[:str], X_2:bat[:oid], X_3:bit):str ", "CMDBATstr_group_concat;", "" ] -[ "aggr", "str_group_concat", "pattern aggr.str_group_concat(X_0:bat[:str], X_1:bat[:str], X_2:bit):str ", "CMDBATstr_group_concat;", "" ] -[ "aggr", "str_group_concat", "pattern aggr.str_group_concat(X_0:bat[:str], X_1:bit):str ", "CMDBATstr_group_concat;", "" ] -[ "aggr", "suball", "pattern aggr.suball(X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:oid], X_3:bat[:oid], X_4:bit):bat[:any_1] ", "SQLall_grp;", "" ] -[ "aggr", "suball", "pattern aggr.suball(X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:oid], X_3:bit):bat[:any_1] ", "SQLall_grp;", "" ] -[ "aggr", "suballnotequal", "pattern aggr.suballnotequal(X_0:bat[:any_1], X_1:bat[:any_1], X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:oid], X_6:bit):bat[:bit] ", "SQLallnotequal_grp2;", "" ] -[ "aggr", "suballnotequal", "pattern aggr.suballnotequal(X_0:bat[:any_1], X_1:bat[:any_1], X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:oid], X_5:bit):bat[:bit] ", "SQLallnotequal_grp2;", "" ] -[ "aggr", "suballnotequal", "pattern aggr.suballnotequal(X_0:bat[:any_1], X_1:bat[:any_1], X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:oid], X_5:bit):bat[:bit] ", "SQLallnotequal_grp;", "" ] -[ "aggr", "suballnotequal", "pattern aggr.suballnotequal(X_0:bat[:any_1], X_1:bat[:any_1], X_2:bat[:oid], X_3:bat[:oid], X_4:bit):bat[:bit] ", "SQLallnotequal_grp;", "" ] -[ "aggr", "subanyequal", "pattern aggr.subanyequal(X_0:bat[:any_1], X_1:bat[:any_1], X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:oid], X_6:bit):bat[:bit] ", "SQLanyequal_grp2;", "" ] -[ "aggr", "subanyequal", "pattern aggr.subanyequal(X_0:bat[:any_1], X_1:bat[:any_1], X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:oid], X_5:bit):bat[:bit] ", "SQLanyequal_grp2;", "" ] -[ "aggr", "subanyequal", "pattern aggr.subanyequal(X_0:bat[:any_1], X_1:bat[:any_1], X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:oid], X_5:bit):bat[:bit] ", "SQLanyequal_grp;", "" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list