Changeset: 023661b8cd75 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=023661b8cd75
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
clients/Tests/exports.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: window-tunning
Log Message:
Approved output
diffs (truncated from 1041 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
@@ -6383,7 +6383,7 @@ stdout of test 'MAL-signatures` in direc
[ "batsql", "lag", "pattern batsql.lag(X_1:bat[:any_1], X_2:bat[:any],
X_3:any_1, X_4:any_2, X_5:any_3):bat[:any_1] ", "SQLlag;", "" ]
[ "batsql", "lag", "pattern batsql.lag(X_1:bat[:any_1], X_2:bat[:any],
X_3:any_2, X_4:any_3):bat[:any_1] ", "SQLlag;", "" ]
[ "batsql", "lag", "pattern batsql.lag(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] ", "SQLlag;", ""
]
-[ "batsql", "last_value", "pattern batsql.last_value(X_1:bat[:any_1],
X_2:bat[:lng], X_3:bat[:lng]):bat[:any_1] ", "SQLlast_value;", ""
]
+[ "batsql", "last_value", "pattern batsql.last_value(X_1:bat[:any_1],
X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:any_1] ", "SQLlast_value;",
"" ]
[ "batsql", "lead", "pattern batsql.lead(X_1:any_1, X_2:any,
X_3:bat[:any_1], X_4:any_2, X_5:any_3):bat[:any_1] ", "SQLlead;", "" ]
[ "batsql", "lead", "pattern batsql.lead(X_1: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:any_1, X_2:bat[:any],
X_3:any_2, X_4:any_3):bat[:any_1] ", "SQLlead;", "" ]
@@ -9355,7 +9355,7 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "exportResult", "unsafe pattern sql.exportResult(X_1:streams,
X_2:int):void ", "mvc_export_result_wrap;", "" ]
[ "sql", "export_table", "unsafe pattern sql.export_table(X_1:str,
X_2:str, X_3:str, X_4:str, X_5:str, X_6:str, X_7:int, X_8:bat[:str],
X_9:bat[:str], X_10:bat[:str], X_11:bat[:int], X_12:bat[:int], X_13:any...):int
", "mvc_export_row_wrap;", "" ]
[ "sql", "export_table", "unsafe pattern sql.export_table(X_1:str,
X_2:str, X_3:str, X_4:str, X_5:str, X_6:str, X_7:int, X_8:bat[:str],
X_9:bat[:str], X_10:bat[:str], X_11:bat[:int], X_12:bat[:int],
X_13:bat[:any]...):int ", "mvc_export_table_wrap;", "" ]
-[ "sql", "first_value", "pattern sql.first_value(X_1:any_1, X_2:lng,
X_3:lng):any_1 ", "SQLfirst_value;", "" ]
+[ "sql", "first_value", "pattern sql.first_value(X_1:any_1, X_2:bit,
X_3:bit, X_4:int, X_5:lng, X_6:lng):any_1 ", "SQLfirst_value;", ""
]
[ "sql", "flush_log", "unsafe command sql.flush_log():void ",
"SQLflush_log;", "" ]
[ "sql", "getVariable", "pattern sql.getVariable(X_1:int, X_2:str,
X_3:str):any_1 ", "getVariable;", "" ]
[ "sql", "getVersion", "command sql.getVersion(X_1:int):lng ",
"mvc_getVersion;", "" ]
@@ -9371,18 +9371,18 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "lag", "pattern sql.lag(X_1:any_1, X_2:any, X_3:any_1,
X_4:bit, X_5:bit):any_1 ", "SQLlag;", "" ]
[ "sql", "lag", "pattern sql.lag(X_1:any_1, X_2:any, X_3:bit,
X_4:bit):any_1 ", "SQLlag;", "" ]
[ "sql", "lag", "pattern sql.lag(X_1:any_1, X_2:bit, X_3:bit):any_1 ",
"SQLlag;", "" ]
-[ "sql", "last_value", "pattern sql.last_value(X_1:any_1, X_2:lng,
X_3:lng):any_1 ", "SQLlast_value;", "" ]
+[ "sql", "last_value", "pattern sql.last_value(X_1:any_1, X_2:bit,
X_3:bit, X_4:int, X_5:lng, X_6:lng):any_1 ", "SQLlast_value;", ""
]
[ "sql", "lead", "pattern sql.lead(X_1:any_1, X_2:any, X_3:any_1,
X_4:bit, X_5:bit):any_1 ", "SQLlead;", "" ]
[ "sql", "lead", "pattern sql.lead(X_1:any_1, X_2:any, X_3:bit,
X_4:bit):any_1 ", "SQLlead;", "" ]
[ "sql", "lead", "pattern sql.lead(X_1:any_1, X_2:bit, X_3:bit):any_1 ",
"SQLlead;", "" ]
[ "sql", "logfile", "unsafe pattern sql.logfile(X_1:str):void ",
"mvc_logfile;", "" ]
-[ "sql", "max", "pattern sql.max(X_1:any_1, X_2:lng, X_3:lng):any_1 ",
"SQLmax;", "" ]
-[ "sql", "min", "pattern sql.min(X_1:any_1, X_2:lng, X_3:lng):any_1 ",
"SQLmin;", "" ]
+[ "sql", "max", "pattern sql.max(X_1:any_1, X_2:bit, X_3:bit, X_4:int,
X_5:lng, X_6:lng):any_1 ", "SQLmax;", "" ]
+[ "sql", "min", "pattern sql.min(X_1:any_1, X_2:bit, X_3:bit, X_4:int,
X_5:lng, X_6:lng):any_1 ", "SQLmin;", "" ]
[ "sql", "ms_trunc", "command sql.ms_trunc(X_1:dbl, X_2:int):dbl ",
"dbl_trunc_wrap;", "" ]
[ "sql", "ms_trunc", "command sql.ms_trunc(X_1:flt, X_2:int):flt ",
"flt_trunc_wrap;", "" ]
[ "sql", "mvc", "pattern sql.mvc():int ", "SQLmvc;", ""
]
[ "sql", "next_value", "unsafe pattern sql.next_value(X_1:str,
X_2:str):lng ", "mvc_next_value;", "" ]
-[ "sql", "nth_value", "pattern sql.nth_value(X_1:any, X_2:any_1,
X_3:lng, X_4:lng):any ", "SQLnth_value;", "" ]
+[ "sql", "nth_value", "pattern sql.nth_value(X_1:any_1, X_2:lng,
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):any_1 ", "SQLnth_value;",
"" ]
[ "sql", "ntile", "pattern sql.ntile(X_1:any, X_2:any_1, X_3:bit,
X_4:bit):any_1 ", "SQLntile;", "" ]
[ "sql", "optimizer_updates", "pattern sql.optimizer_updates():void
", "SQLoptimizersUpdate;", "" ]
[ "sql", "optimizers", "command sql.optimizers() (X_0:bat[:str],
X_1:bat[:str], X_2:bat[:str]) ", "getPipeCatalog;", "" ]
diff --git a/clients/Tests/MAL-signatures.stable.out.int128
b/clients/Tests/MAL-signatures.stable.out.int128
--- a/clients/Tests/MAL-signatures.stable.out.int128
+++ b/clients/Tests/MAL-signatures.stable.out.int128
@@ -8824,89 +8824,89 @@ 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[:hge], 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[:hge], X_2:bat[:lng],
X_3:bat[:lng]):bat[:hge] ", "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[:hge], X_2:bat[:hge],
X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;", "" ]
-[ "batsql", "corr", "pattern batsql.corr(X_1:bat[:hge], X_2:hge,
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:hge, X_2:bat[:hge], 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[:hge],
X_2:bat[:hge], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;",
"" ]
-[ "batsql", "covariance", "pattern batsql.covariance(X_1:bat[:hge],
X_2:hge, 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:hge,
X_2:bat[:hge], 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[:hge],
X_2:bat[:hge], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;",
"" ]
-[ "batsql", "covariancep", "pattern batsql.covariancep(X_1:bat[:hge],
X_2:hge, 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:hge,
X_2:bat[:hge], 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[:hge], 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[:hge], X_2:any, X_3:any,
X_4:int, X_5:any, X_6:any):bat[:hge] ", "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[:hge], X_2:bat[:hge],
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[:hge], X_2:hge, 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:hge, X_2:bat[:hge], 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[:hge],
X_2:bat[:hge], 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[:hge],
X_2:hge, 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:hge,
X_2:bat[:hge], 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[:hge],
X_2:bat[:hge], 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[:hge],
X_2:hge, 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:hge,
X_2:bat[:hge], 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;", "" ]
@@ -8924,7 +8924,7 @@ stdout of test 'MAL-signatures` in direc
[ "batsql", "lag", "pattern batsql.lag(X_1:bat[:any_1], X_2:bat[:any],
X_3:any_1, X_4:any_2, X_5:any_3):bat[:any_1] ", "SQLlag;", "" ]
[ "batsql", "lag", "pattern batsql.lag(X_1:bat[:any_1], X_2:bat[:any],
X_3:any_2, X_4:any_3):bat[:any_1] ", "SQLlag;", "" ]
[ "batsql", "lag", "pattern batsql.lag(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] ", "SQLlag;", ""
]
-[ "batsql", "last_value", "pattern batsql.last_value(X_1:bat[:any_1],
X_2:bat[:lng], X_3:bat[:lng]):bat[:any_1] ", "SQLlast_value;", ""
]
+[ "batsql", "last_value", "pattern batsql.last_value(X_1:bat[:any_1],
X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:any_1] ", "SQLlast_value;",
"" ]
[ "batsql", "lead", "pattern batsql.lead(X_1:any_1, X_2:any,
X_3:bat[:any_1], X_4:any_2, X_5:any_3):bat[:any_1] ", "SQLlead;", "" ]
[ "batsql", "lead", "pattern batsql.lead(X_1: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:any_1, X_2:bat[:any],
X_3:any_2, X_4:any_3):bat[:any_1] ", "SQLlead;", "" ]
@@ -8936,31 +8936,31 @@ 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[:hge] ", "SQLprod;", "" ]
-[ "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[:hge], X_2:bat[:lng],
X_3:bat[:lng]):bat[:hge] ", "SQLprod;", "" ]
-[ "batsql", "prod", "pattern batsql.prod(X_1:bat[:int], X_2:bat[:lng],
X_3:bat[:lng]):bat[:hge] ", "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[:hge] ", "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[:hge] ", "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[:hge] ", "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[:hge], X_2:any, X_3:any,
X_4:int, X_5:any, X_6:any):bat[:hge] ", "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[:hge] ", "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[:hge] ", "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[:hge] ", "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;", "" ]
@@ -8970,51 +8970,51 @@ 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[:hge],
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[:hge],
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[:hge], 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;", ""
]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
