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

Reply via email to