Changeset: b8e13580aebe for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b8e13580aebe Modified Files: clients/Tests/MAL-signatures.stable.out sql/test/sys-schema/Tests/systemfunctions.stable.out Branch: window-tunning Log Message:
Approved no int128 output diffs (truncated from 623 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 @@ -6294,78 +6294,78 @@ stdout of test 'MAL-signatures` in direc [ "batsql", "any", "pattern batsql.any(X_1:bit, X_2:bat[:bit], X_3:bat[:bit]):bat[:bit] ", "SQLany_cmp;", "" ] [ "batsql", "any", "pattern batsql.any(X_1:bit, X_2:bat[:bit], X_3:bit):bat[:bit] ", "SQLany_cmp;", "" ] [ "batsql", "any", "pattern batsql.any(X_1:bit, X_2:bit, X_3:bat[:bit]):bat[:bit] ", "SQLany_cmp;", "" ] -[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:bte], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLavg;", "" ] -[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:dbl], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLavg;", "" ] -[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:flt], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLavg;", "" ] -[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:int], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLavg;", "" ] -[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:lng], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLavg;", "" ] -[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:sht], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLavg;", "" ] -[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:bte], X_2:bat[:lng], X_3:bat[:lng]):bat[:bte] ", "SQLavginteger;", "" ] -[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:int], X_2:bat[:lng], X_3:bat[:lng]):bat[:int] ", "SQLavginteger;", "" ] -[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:lng], X_2:bat[:lng], X_3:bat[:lng]):bat[:lng] ", "SQLavginteger;", "" ] -[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:sht], X_2:bat[:lng], X_3:bat[:lng]):bat[:sht] ", "SQLavginteger;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:bte], X_2:bat[:bte], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:bte], X_2:bte, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:dbl], X_2:bat[:dbl], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:dbl], X_2:dbl, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:flt], X_2:bat[:flt], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:flt], X_2:flt, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:int], X_2:bat[:int], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:int], X_2:int, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:lng], X_2:bat[:lng], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:lng], X_2:lng, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:sht], X_2:bat[:sht], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:sht], X_2:sht, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:bte, X_2:bat[:bte], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:dbl, X_2:bat[:dbl], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:flt, X_2:bat[:flt], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:int, X_2:bat[:int], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:lng, X_2:bat[:lng], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "corr", "pattern batsql.corr(X_1:sht, X_2:bat[:sht], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcorr;", "" ] -[ "batsql", "count", "pattern batsql.count(X_1:bat[:any_1], X_2:bit, X_3:bat[:lng], X_4:bat[:lng]):bat[:lng] ", "SQLcount;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:bte], X_2:bat[:bte], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:bte], X_2:bte, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:dbl], X_2:bat[:dbl], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:dbl], X_2:dbl, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:flt], X_2:bat[:flt], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:flt], X_2:flt, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:int], X_2:bat[:int], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:int], X_2:int, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:lng], X_2:bat[:lng], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:lng], X_2:lng, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:sht], X_2:bat[:sht], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:sht], X_2:sht, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:bte, X_2:bat[:bte], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:dbl, X_2:bat[:dbl], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:flt, X_2:bat[:flt], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:int, X_2:bat[:int], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:lng, X_2:bat[:lng], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariance", "pattern batsql.covariance(X_1:sht, X_2:bat[:sht], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcovar_samp;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:bte], X_2:bat[:bte], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:bte], X_2:bte, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:dbl], X_2:bat[:dbl], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:dbl], X_2:dbl, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:flt], X_2:bat[:flt], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:flt], X_2:flt, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:int], X_2:bat[:int], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:int], X_2:int, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:lng], X_2:bat[:lng], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:lng], X_2:lng, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:sht], X_2:bat[:sht], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:sht], X_2:sht, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bte, X_2:bat[:bte], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:dbl, X_2:bat[:dbl], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:flt, X_2:bat[:flt], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:int, X_2:bat[:int], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:lng, X_2:bat[:lng], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcovar_pop;", "" ] -[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:sht, X_2:bat[:sht], X_3:lng, X_4:lng):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:bte], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLavg;", "" ] +[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:dbl], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLavg;", "" ] +[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:flt], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLavg;", "" ] +[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:int], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLavg;", "" ] +[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLavg;", "" ] +[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:sht], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLavg;", "" ] +[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:bte], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:bte] ", "SQLavginteger;", "" ] +[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:int], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:int] ", "SQLavginteger;", "" ] +[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:lng] ", "SQLavginteger;", "" ] +[ "batsql", "avg", "pattern batsql.avg(X_1:bat[:sht], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:sht] ", "SQLavginteger;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:bte], X_2:bat[:bte], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:bte], X_2:bte, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:dbl], X_2:bat[:dbl], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:dbl], X_2:dbl, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:flt], X_2:bat[:flt], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:flt], X_2:flt, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:int], X_2:bat[:int], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:int], X_2:int, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:lng], X_2:bat[:lng], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:lng], X_2:lng, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:sht], X_2:bat[:sht], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:sht], X_2:sht, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:bte, X_2:bat[:bte], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:dbl, X_2:bat[:dbl], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:flt, X_2:bat[:flt], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:int, X_2:bat[:int], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:lng, X_2:bat[:lng], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "corr", "pattern batsql.corr(X_1:sht, X_2:bat[:sht], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcorr;", "" ] +[ "batsql", "count", "pattern batsql.count(X_1:bat[:any_1], X_2:bit, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:lng] ", "SQLcount;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:bte], X_2:bat[:bte], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:bte], X_2:bte, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:dbl], X_2:bat[:dbl], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:dbl], X_2:dbl, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:flt], X_2:bat[:flt], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:flt], X_2:flt, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:int], X_2:bat[:int], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:int], X_2:int, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:lng], X_2:bat[:lng], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:lng], X_2:lng, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:sht], X_2:bat[:sht], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:sht], X_2:sht, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:bte, X_2:bat[:bte], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:dbl, X_2:bat[:dbl], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:flt, X_2:bat[:flt], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:int, X_2:bat[:int], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:lng, X_2:bat[:lng], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariance", "pattern batsql.covariance(X_1:sht, X_2:bat[:sht], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_samp;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:bte], X_2:bat[:bte], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:bte], X_2:bte, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:dbl], X_2:bat[:dbl], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:dbl], X_2:dbl, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:flt], X_2:bat[:flt], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:flt], X_2:flt, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:int], X_2:bat[:int], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:int], X_2:int, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:lng], X_2:bat[:lng], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:lng], X_2:lng, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:sht], X_2:bat[:sht], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:sht], X_2:sht, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bte, X_2:bat[:bte], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:dbl, X_2:bat[:dbl], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:flt, X_2:bat[:flt], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:int, X_2:bat[:int], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:lng, X_2:bat[:lng], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] +[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:sht, X_2:bat[:sht], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ", "SQLcovar_pop;", "" ] [ "batsql", "cume_dist", "pattern batsql.cume_dist(X_1:bat[:any_1], X_2:any_2, X_3:any_3):bat[:dbl] ", "SQLcume_dist;", "" ] [ "batsql", "dense_rank", "pattern batsql.dense_rank(X_1:bat[:any_1], X_2:any_2, X_3:any_3):bat[:int] ", "SQLdense_rank;", "" ] [ "batsql", "diff", "pattern batsql.diff(X_1:bat[:any_1]):bat[:bit] ", "SQLdiff;", "" ] [ "batsql", "diff", "pattern batsql.diff(X_1:bat[:bit], X_2:any_1):bat[:bit] ", "SQLdiff;", "" ] [ "batsql", "diff", "pattern batsql.diff(X_1:bat[:bit], X_2:bat[:any_1]):bat[:bit] ", "SQLdiff;", "" ] [ "batsql", "diff", "pattern batsql.diff(X_1:bit, X_2:bat[:any_1]):bat[:bit] ", "SQLdiff;", "" ] -[ "batsql", "first_value", "pattern batsql.first_value(X_1:bat[:any_1], X_2:bat[:lng], X_3:bat[:lng]):bat[:any_1] ", "SQLfirst_value;", "" ] +[ "batsql", "first_value", "pattern batsql.first_value(X_1:bat[:any_1], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:any_1] ", "SQLfirst_value;", "" ] [ "batsql", "get_value", "pattern batsql.get_value(X_1:bat[:str], X_2:bat[:str]):bat[:lng] ", "mvc_bat_get_value;", "" ] [ "batsql", "get_value", "pattern batsql.get_value(X_1:bat[:str], X_2:str):bat[:lng] ", "mvc_bat_get_value;", "" ] [ "batsql", "get_value", "pattern batsql.get_value(X_1:str, X_2:bat[:str]):bat[:lng] ", "mvc_bat_get_value;", "" ] @@ -6395,26 +6395,26 @@ stdout of test 'MAL-signatures` in direc [ "batsql", "lead", "pattern batsql.lead(X_1:bat[:any_1], X_2:bat[:any], X_3:any_1, X_4:any_2, X_5:any_3):bat[:any_1] ", "SQLlead;", "" ] [ "batsql", "lead", "pattern batsql.lead(X_1:bat[:any_1], X_2:bat[:any], X_3:any_2, X_4:any_3):bat[:any_1] ", "SQLlead;", "" ] [ "batsql", "lead", "pattern batsql.lead(X_1:bat[:any_1], X_2:bat[:any], X_3:bat[:any_1], X_4:any_2, X_5:any_3):bat[:any_1] ", "SQLlead;", "" ] -[ "batsql", "max", "pattern batsql.max(X_1:bat[:any_1], X_2:bat[:lng], X_3:bat[:lng]):bat[:any_1] ", "SQLmax;", "" ] -[ "batsql", "min", "pattern batsql.min(X_1:bat[:any_1], X_2:bat[:lng], X_3:bat[:lng]):bat[:any_1] ", "SQLmin;", "" ] +[ "batsql", "max", "pattern batsql.max(X_1:bat[:any_1], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:any_1] ", "SQLmax;", "" ] +[ "batsql", "min", "pattern batsql.min(X_1:bat[:any_1], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:any_1] ", "SQLmin;", "" ] [ "batsql", "next_value", "unsafe pattern batsql.next_value(X_1:bat[:str], X_2:bat[:str]):bat[:lng] ", "mvc_bat_next_value;", "" ] [ "batsql", "next_value", "unsafe pattern batsql.next_value(X_1:bat[:str], X_2:str):bat[:lng] ", "mvc_bat_next_value;", "" ] [ "batsql", "next_value", "unsafe pattern batsql.next_value(X_1:str, X_2:bat[:str]):bat[:lng] ", "mvc_bat_next_value;", "" ] -[ "batsql", "nth_value", "pattern batsql.nth_value(X_1:any, X_2:bat[:any_1], X_3:lng, X_4:lng):bat[:any] ", "SQLnth_value;", "" ] -[ "batsql", "nth_value", "pattern batsql.nth_value(X_1:bat[:any], X_2:any_1, X_3:bat[:lng], X_4:bat[:lng]):bat[:any] ", "SQLnth_value;", "" ] -[ "batsql", "nth_value", "pattern batsql.nth_value(X_1:bat[:any], X_2:bat[:any_1], X_3:bat[:lng], X_4:bat[:lng]):bat[:any] ", "SQLnth_value;", "" ] +[ "batsql", "nth_value", "pattern batsql.nth_value(X_1:any_1, X_2:bat[:lng], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:any_1] ", "SQLnth_value;", "" ] +[ "batsql", "nth_value", "pattern batsql.nth_value(X_1:bat[:any_1], X_2:bat[:lng], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:any_1] ", "SQLnth_value;", "" ] +[ "batsql", "nth_value", "pattern batsql.nth_value(X_1:bat[:any_1], X_2:lng, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:any_1] ", "SQLnth_value;", "" ] [ "batsql", "ntile", "pattern batsql.ntile(X_1:any, X_2:bat[:any_1], X_3:any_2, X_4:any_3):bat[:any_1] ", "SQLntile;", "" ] [ "batsql", "ntile", "pattern batsql.ntile(X_1:bat[:any], X_2:any_1, X_3:any_2, X_4:any_3):bat[:any_1] ", "SQLntile;", "" ] [ "batsql", "ntile", "pattern batsql.ntile(X_1:bat[:any], X_2:bat[:any_1], X_3:any_2, X_4:any_3):bat[:any_1] ", "SQLntile;", "" ] [ "batsql", "password", "pattern batsql.password(X_1:bat[:str]):bat[:str] ", "db_password_wrap;", "" ] [ "batsql", "percent_rank", "pattern batsql.percent_rank(X_1:bat[:any_1], X_2:any_2, X_3:any_3):bat[:dbl] ", "SQLpercent_rank;", "" ] -[ "batsql", "prod", "pattern batsql.prod(X_1:bat[:bte], X_2:bat[:lng], X_3:bat[:lng]):bat[:lng] ", "SQLprod;", "" ] -[ "batsql", "prod", "pattern batsql.prod(X_1:bat[:dbl], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLprod;", "" ] -[ "batsql", "prod", "pattern batsql.prod(X_1:bat[:flt], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLprod;", "" ] -[ "batsql", "prod", "pattern batsql.prod(X_1:bat[:flt], X_2:bat[:lng], X_3:bat[:lng]):bat[:flt] ", "SQLprod;", "" ] -[ "batsql", "prod", "pattern batsql.prod(X_1:bat[:int], X_2:bat[:lng], X_3:bat[:lng]):bat[:lng] ", "SQLprod;", "" ] -[ "batsql", "prod", "pattern batsql.prod(X_1:bat[:lng], X_2:bat[:lng], X_3:bat[:lng]):bat[:lng] ", "SQLprod;", "" ] -[ "batsql", "prod", "pattern batsql.prod(X_1:bat[:sht], X_2:bat[:lng], X_3:bat[:lng]):bat[:lng] ", "SQLprod;", "" ] +[ "batsql", "prod", "pattern batsql.prod(X_1:bat[:bte], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:lng] ", "SQLprod;", "" ] +[ "batsql", "prod", "pattern batsql.prod(X_1:bat[:dbl], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLprod;", "" ] +[ "batsql", "prod", "pattern batsql.prod(X_1:bat[:flt], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLprod;", "" ] +[ "batsql", "prod", "pattern batsql.prod(X_1:bat[:flt], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:flt] ", "SQLprod;", "" ] +[ "batsql", "prod", "pattern batsql.prod(X_1:bat[:int], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:lng] ", "SQLprod;", "" ] +[ "batsql", "prod", "pattern batsql.prod(X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:lng] ", "SQLprod;", "" ] +[ "batsql", "prod", "pattern batsql.prod(X_1:bat[:sht], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:lng] ", "SQLprod;", "" ] [ "batsql", "rank", "pattern batsql.rank(X_1:bat[:any_1], X_2:any_2, X_3:any_3):bat[:int] ", "SQLrank;", "" ] [ "batsql", "restart", "unsafe pattern batsql.restart(X_1:bat[:str], X_2:bat[:str], X_3:bat[:lng]):bat[:lng] ", "mvc_bat_restart_seq;", "" ] [ "batsql", "restart", "unsafe pattern batsql.restart(X_1:bat[:str], X_2:bat[:str], X_3:lng):bat[:lng] ", "mvc_bat_restart_seq;", "" ] @@ -6424,42 +6424,42 @@ stdout of test 'MAL-signatures` in direc [ "batsql", "restart", "unsafe pattern batsql.restart(X_1:str, X_2:bat[:str], X_3:lng):bat[:lng] ", "mvc_bat_restart_seq;", "" ] [ "batsql", "restart", "unsafe pattern batsql.restart(X_1:str, X_2:str, X_3:bat[:lng]):bat[:lng] ", "mvc_bat_restart_seq;", "" ] [ "batsql", "row_number", "pattern batsql.row_number(X_1:bat[:any_1], X_2:any_2, X_3:any_3):bat[:int] ", "SQLrow_number;", "" ] -[ "batsql", "stdev", "pattern batsql.stdev(X_1:bat[:bte], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_samp;", "" ] -[ "batsql", "stdev", "pattern batsql.stdev(X_1:bat[:dbl], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_samp;", "" ] -[ "batsql", "stdev", "pattern batsql.stdev(X_1:bat[:flt], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_samp;", "" ] -[ "batsql", "stdev", "pattern batsql.stdev(X_1:bat[:int], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_samp;", "" ] -[ "batsql", "stdev", "pattern batsql.stdev(X_1:bat[:lng], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_samp;", "" ] -[ "batsql", "stdev", "pattern batsql.stdev(X_1:bat[:sht], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_samp;", "" ] -[ "batsql", "stdevp", "pattern batsql.stdevp(X_1:bat[:bte], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_pop;", "" ] -[ "batsql", "stdevp", "pattern batsql.stdevp(X_1:bat[:dbl], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_pop;", "" ] -[ "batsql", "stdevp", "pattern batsql.stdevp(X_1:bat[:flt], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_pop;", "" ] -[ "batsql", "stdevp", "pattern batsql.stdevp(X_1:bat[:int], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_pop;", "" ] -[ "batsql", "stdevp", "pattern batsql.stdevp(X_1:bat[:lng], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_pop;", "" ] -[ "batsql", "stdevp", "pattern batsql.stdevp(X_1:bat[:sht], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_pop;", "" ] -[ "batsql", "str_group_concat", "pattern batsql.str_group_concat(X_1:bat[:str], X_2:bat[:lng], X_3:bat[:lng]):bat[:str] ", "SQLstrgroup_concat;", "" ] -[ "batsql", "str_group_concat", "pattern batsql.str_group_concat(X_1:bat[:str], X_2:bat[:str], X_3:bat[:lng], X_4:bat[:lng]):bat[:str] ", "SQLstrgroup_concat;", "" ] -[ "batsql", "str_group_concat", "pattern batsql.str_group_concat(X_1:bat[:str], X_2:str, X_3:bat[:lng], X_4:bat[:lng]):bat[:str] ", "SQLstrgroup_concat;", "" ] -[ "batsql", "str_group_concat", "pattern batsql.str_group_concat(X_1:str, X_2:bat[:str], X_3:lng, X_4:lng):bat[:str] ", "SQLstrgroup_concat;", "" ] +[ "batsql", "stdev", "pattern batsql.stdev(X_1:bat[:bte], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLstddev_samp;", "" ] +[ "batsql", "stdev", "pattern batsql.stdev(X_1:bat[:dbl], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLstddev_samp;", "" ] +[ "batsql", "stdev", "pattern batsql.stdev(X_1:bat[:flt], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLstddev_samp;", "" ] +[ "batsql", "stdev", "pattern batsql.stdev(X_1:bat[:int], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLstddev_samp;", "" ] +[ "batsql", "stdev", "pattern batsql.stdev(X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLstddev_samp;", "" ] +[ "batsql", "stdev", "pattern batsql.stdev(X_1:bat[:sht], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLstddev_samp;", "" ] +[ "batsql", "stdevp", "pattern batsql.stdevp(X_1:bat[:bte], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLstddev_pop;", "" ] +[ "batsql", "stdevp", "pattern batsql.stdevp(X_1:bat[:dbl], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLstddev_pop;", "" ] +[ "batsql", "stdevp", "pattern batsql.stdevp(X_1:bat[:flt], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLstddev_pop;", "" ] +[ "batsql", "stdevp", "pattern batsql.stdevp(X_1:bat[:int], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLstddev_pop;", "" ] +[ "batsql", "stdevp", "pattern batsql.stdevp(X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLstddev_pop;", "" ] +[ "batsql", "stdevp", "pattern batsql.stdevp(X_1:bat[:sht], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLstddev_pop;", "" ] +[ "batsql", "str_group_concat", "pattern batsql.str_group_concat(X_1:bat[:str], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:str] ", "SQLstrgroup_concat;", "" ] +[ "batsql", "str_group_concat", "pattern batsql.str_group_concat(X_1:bat[:str], X_2:bat[:str], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:str] ", "SQLstrgroup_concat;", "" ] +[ "batsql", "str_group_concat", "pattern batsql.str_group_concat(X_1:bat[:str], X_2:str, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:str] ", "SQLstrgroup_concat;", "" ] +[ "batsql", "str_group_concat", "pattern batsql.str_group_concat(X_1:str, X_2:bat[:str], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:str] ", "SQLstrgroup_concat;", "" ] [ "batsql", "strings", "command batsql.strings(X_1:bat[:str]):bat[:str] ", "BATSTRstrings;", "" ] -[ "batsql", "sum", "pattern batsql.sum(X_1:bat[:bte], X_2:bat[:lng], X_3:bat[:lng]):bat[:lng] ", "SQLsum;", "" ] -[ "batsql", "sum", "pattern batsql.sum(X_1:bat[:dbl], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLsum;", "" ] -[ "batsql", "sum", "pattern batsql.sum(X_1:bat[:flt], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLsum;", "" ] -[ "batsql", "sum", "pattern batsql.sum(X_1:bat[:flt], X_2:bat[:lng], X_3:bat[:lng]):bat[:flt] ", "SQLsum;", "" ] -[ "batsql", "sum", "pattern batsql.sum(X_1:bat[:int], X_2:bat[:lng], X_3:bat[:lng]):bat[:lng] ", "SQLsum;", "" ] -[ "batsql", "sum", "pattern batsql.sum(X_1:bat[:lng], X_2:bat[:lng], X_3:bat[:lng]):bat[:lng] ", "SQLsum;", "" ] -[ "batsql", "sum", "pattern batsql.sum(X_1:bat[:sht], X_2:bat[:lng], X_3:bat[:lng]):bat[:lng] ", "SQLsum;", "" ] -[ "batsql", "variance", "pattern batsql.variance(X_1:bat[:bte], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLvar_samp;", "" ] -[ "batsql", "variance", "pattern batsql.variance(X_1:bat[:dbl], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLvar_samp;", "" ] -[ "batsql", "variance", "pattern batsql.variance(X_1:bat[:flt], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLvar_samp;", "" ] -[ "batsql", "variance", "pattern batsql.variance(X_1:bat[:int], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLvar_samp;", "" ] -[ "batsql", "variance", "pattern batsql.variance(X_1:bat[:lng], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLvar_samp;", "" ] -[ "batsql", "variance", "pattern batsql.variance(X_1:bat[:sht], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLvar_samp;", "" ] -[ "batsql", "variancep", "pattern batsql.variancep(X_1:bat[:bte], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLvar_pop;", "" ] -[ "batsql", "variancep", "pattern batsql.variancep(X_1:bat[:dbl], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLvar_pop;", "" ] -[ "batsql", "variancep", "pattern batsql.variancep(X_1:bat[:flt], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLvar_pop;", "" ] -[ "batsql", "variancep", "pattern batsql.variancep(X_1:bat[:int], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLvar_pop;", "" ] -[ "batsql", "variancep", "pattern batsql.variancep(X_1:bat[:lng], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLvar_pop;", "" ] -[ "batsql", "variancep", "pattern batsql.variancep(X_1:bat[:sht], X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLvar_pop;", "" ] +[ "batsql", "sum", "pattern batsql.sum(X_1:bat[:bte], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:lng] ", "SQLsum;", "" ] +[ "batsql", "sum", "pattern batsql.sum(X_1:bat[:dbl], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLsum;", "" ] +[ "batsql", "sum", "pattern batsql.sum(X_1:bat[:flt], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLsum;", "" ] +[ "batsql", "sum", "pattern batsql.sum(X_1:bat[:flt], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:flt] ", "SQLsum;", "" ] +[ "batsql", "sum", "pattern batsql.sum(X_1:bat[:int], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:lng] ", "SQLsum;", "" ] +[ "batsql", "sum", "pattern batsql.sum(X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:lng] ", "SQLsum;", "" ] +[ "batsql", "sum", "pattern batsql.sum(X_1:bat[:sht], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:lng] ", "SQLsum;", "" ] +[ "batsql", "variance", "pattern batsql.variance(X_1:bat[:bte], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLvar_samp;", "" ] +[ "batsql", "variance", "pattern batsql.variance(X_1:bat[:dbl], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLvar_samp;", "" ] +[ "batsql", "variance", "pattern batsql.variance(X_1:bat[:flt], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLvar_samp;", "" ] +[ "batsql", "variance", "pattern batsql.variance(X_1:bat[:int], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLvar_samp;", "" ] +[ "batsql", "variance", "pattern batsql.variance(X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLvar_samp;", "" ] +[ "batsql", "variance", "pattern batsql.variance(X_1:bat[:sht], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLvar_samp;", "" ] +[ "batsql", "variancep", "pattern batsql.variancep(X_1:bat[:bte], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLvar_pop;", "" ] +[ "batsql", "variancep", "pattern batsql.variancep(X_1:bat[:dbl], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLvar_pop;", "" ] +[ "batsql", "variancep", "pattern batsql.variancep(X_1:bat[:flt], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLvar_pop;", "" ] +[ "batsql", "variancep", "pattern batsql.variancep(X_1:bat[:int], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLvar_pop;", "" ] +[ "batsql", "variancep", "pattern batsql.variancep(X_1:bat[:lng], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLvar_pop;", "" ] +[ "batsql", "variancep", "pattern batsql.variancep(X_1:bat[:sht], X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:dbl] ", "SQLvar_pop;", "" ] [ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], X_2:int, X_3:int, X_4:int, X_5:bat[:bte]):bat[:lng] ", "SQLwindow_bound;", "" ] [ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], X_2:int, X_3:int, X_4:int, X_5:bat[:dbl]):bat[:lng] ", "SQLwindow_bound;", "" ] [ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1], X_2:int, X_3:int, X_4:int, X_5:bat[:flt]):bat[:lng] ", "SQLwindow_bound;", "" ] @@ -9273,16 +9273,16 @@ stdout of test 'MAL-signatures` in direc [ "sql", "assert", "pattern sql.assert(X_1:bit, X_2:str):void ", "SQLassert;", "" ] [ "sql", "assert", "pattern sql.assert(X_1:int, X_2:str):void ", "SQLassertInt;", "" ] [ "sql", "assert", "pattern sql.assert(X_1:lng, X_2:str):void ", "SQLassertLng;", "" ] -[ "sql", "avg", "pattern sql.avg(X_1:bte, X_2:lng, X_3:lng):dbl ", "SQLavg;", "" ] -[ "sql", "avg", "pattern sql.avg(X_1:dbl, X_2:lng, X_3:lng):dbl ", "SQLavg;", "" ] -[ "sql", "avg", "pattern sql.avg(X_1:flt, X_2:lng, X_3:lng):dbl ", "SQLavg;", "" ] -[ "sql", "avg", "pattern sql.avg(X_1:int, X_2:lng, X_3:lng):dbl ", "SQLavg;", "" ] -[ "sql", "avg", "pattern sql.avg(X_1:lng, X_2:lng, X_3:lng):dbl ", "SQLavg;", "" ] -[ "sql", "avg", "pattern sql.avg(X_1:sht, X_2:lng, X_3:lng):dbl ", "SQLavg;", "" ] -[ "sql", "avg", "pattern sql.avg(X_1:bte, X_2:lng, X_3:lng):bte ", "SQLavginteger;", "" ] -[ "sql", "avg", "pattern sql.avg(X_1:int, X_2:lng, X_3:lng):int ", "SQLavginteger;", "" ] -[ "sql", "avg", "pattern sql.avg(X_1:lng, X_2:lng, X_3:lng):lng ", "SQLavginteger;", "" ] -[ "sql", "avg", "pattern sql.avg(X_1:sht, X_2:lng, X_3:lng):sht ", "SQLavginteger;", "" ] +[ "sql", "avg", "pattern sql.avg(X_1:bte, X_2:bit, X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLavg;", "" ] +[ "sql", "avg", "pattern sql.avg(X_1:dbl, X_2:bit, X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLavg;", "" ] +[ "sql", "avg", "pattern sql.avg(X_1:flt, X_2:bit, X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLavg;", "" ] +[ "sql", "avg", "pattern sql.avg(X_1:int, X_2:bit, X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLavg;", "" ] +[ "sql", "avg", "pattern sql.avg(X_1:lng, X_2:bit, X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLavg;", "" ] +[ "sql", "avg", "pattern sql.avg(X_1:sht, X_2:bit, X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLavg;", "" ] +[ "sql", "avg", "pattern sql.avg(X_1:bte, X_2:bit, X_3:bit, X_4:int, X_5:lng, X_6:lng):bte ", "SQLavginteger;", "" ] +[ "sql", "avg", "pattern sql.avg(X_1:int, X_2:bit, X_3:bit, X_4:int, X_5:lng, X_6:lng):int ", "SQLavginteger;", "" ] +[ "sql", "avg", "pattern sql.avg(X_1:lng, X_2:bit, X_3:bit, X_4:int, X_5:lng, X_6:lng):lng ", "SQLavginteger;", "" ] +[ "sql", "avg", "pattern sql.avg(X_1:sht, X_2:bit, X_3:bit, X_4:int, X_5:lng, X_6:lng):sht ", "SQLavginteger;", "" ] [ "sql", "bind", "pattern sql.bind(X_1:int, X_2:str, X_3:str, X_4:str, X_5:int):bat[:any_1] ", "mvc_bind_wrap;", "" ] [ "sql", "bind", "pattern sql.bind(X_1:int, X_2:str, X_3:str, X_4:str, X_5:int, X_6:int, X_7:int):bat[:any_1] ", "mvc_bind_wrap;", "" ] [ "sql", "bind", "pattern sql.bind(X_2:int, X_3:str, X_4:str, X_5:str, X_6:int) (X_0:bat[:oid], X_1:bat[:any_1]) ", "mvc_bind_wrap;", "" ] @@ -9296,25 +9296,25 @@ stdout of test 'MAL-signatures` in direc [ "sql", "copy_from", "unsafe pattern sql.copy_from(X_1:ptr, X_2:str, X_3:str, X_4:str, X_5:str, X_6:str, X_7:lng, X_8:lng, X_9:int, X_10:int, X_11:str, X_12:int, X_13:int):bat[:any]... ", "mvc_import_table_wrap;", "" ] [ "sql", "copy_rejects", "pattern sql.copy_rejects() (X_0:bat[:lng], X_1:bat[:int], X_2:bat[:str], X_3:bat[:str]) ", "COPYrejects;", "" ] [ "sql", "copy_rejects_clear", "unsafe pattern sql.copy_rejects_clear():void ", "COPYrejects_clear;", "" ] -[ "sql", "corr", "pattern sql.corr(X_1:bte, X_2:bte, X_3:lng, X_4:lng):dbl ", "SQLcorr;", "" ] -[ "sql", "corr", "pattern sql.corr(X_1:dbl, X_2:dbl, X_3:lng, X_4:lng):dbl ", "SQLcorr;", "" ] -[ "sql", "corr", "pattern sql.corr(X_1:flt, X_2:flt, X_3:lng, X_4:lng):dbl ", "SQLcorr;", "" ] -[ "sql", "corr", "pattern sql.corr(X_1:int, X_2:int, X_3:lng, X_4:lng):dbl ", "SQLcorr;", "" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list