Changeset: 4b4b2353a8a1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4b4b2353a8a1 Branch: default Log Message:
Merge with Jan2022 branch. diffs (truncated from 137750 to 300 lines): diff --git a/clients/Tests/All b/clients/Tests/All --- a/clients/Tests/All +++ b/clients/Tests/All @@ -1,4 +1,5 @@ exports -HAVE_FITS&HAVE_GEOM&HAVE_LIBR&HAVE_LIBPY3&HAVE_NETCDF&HAVE_SHP&NOT_WIN32?MAL-signatures +HAVE_HGE&HAVE_FITS&HAVE_GEOM&HAVE_LIBR&HAVE_LIBPY3&HAVE_NETCDF&HAVE_SHP&NOT_WIN32?MAL-signatures-hge +!HAVE_HGE&HAVE_FITS&HAVE_GEOM&HAVE_LIBR&HAVE_LIBPY3&HAVE_NETCDF&HAVE_SHP&NOT_WIN32?MAL-signatures #MERCURIAL?malcheck mclient-uri diff --git a/clients/Tests/MAL-signatures-hge.test b/clients/Tests/MAL-signatures-hge.test new file mode 100644 --- /dev/null +++ b/clients/Tests/MAL-signatures-hge.test @@ -0,0 +1,65665 @@ +hash-threshold 100000 +query TTTTT nosort +select * from sys.malfunctions() order by module, "function", address, signature, comment +---- +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; +(empty) +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[:hge], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] +AGGRavg13_dbl; +Grouped tail average on hge +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[:hge], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) +AGGRavg23_dbl; +Grouped tail average on hge, 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[:hge], X_1:bat[:oid], X_2:bit) (X_3:hge, 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[:hge], X_1:bat[:lng], X_2:bat[:lng]):hge +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[:hge], X_1:bat[:hge], 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]):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; +(empty) +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@BUNs 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 _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
