Changeset: bd7e03b0211d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bd7e03b0211d
Modified Files:
clients/Tests/MAL-signatures.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out
Branch: window-tunning
Log Message:
Approved output
diffs (truncated from 461 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
@@ -6460,30 +6460,30 @@ stdout of test 'MAL-signatures` in direc
[ "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;",
"" ]
-[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:any_1],
X_2:int, X_3:int, X_4:int, X_5:bat[:int]):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[:lng]):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[:sht]):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: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: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:flt):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:int):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:lng):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:sht):bat[:lng] ", "SQLwindow_bound;", ""
]
-[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:bte]):bat[:lng] ",
"SQLwindow_bound;", "" ]
-[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:dbl]):bat[:lng] ",
"SQLwindow_bound;", "" ]
-[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:flt]):bat[:lng] ",
"SQLwindow_bound;", "" ]
-[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:int]):bat[:lng] ",
"SQLwindow_bound;", "" ]
-[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:lng]):bat[:lng] ",
"SQLwindow_bound;", "" ]
-[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:sht]):bat[:lng] ",
"SQLwindow_bound;", "" ]
-[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bte):bat[:lng] ",
"SQLwindow_bound;", "" ]
-[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:dbl):bat[:lng] ",
"SQLwindow_bound;", "" ]
-[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:flt):bat[:lng] ",
"SQLwindow_bound;", "" ]
-[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:int):bat[:lng] ",
"SQLwindow_bound;", "" ]
-[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:lng):bat[:lng] ",
"SQLwindow_bound;", "" ]
-[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:sht):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[:bte]):bat[:oid] ", "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[:oid] ", "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[:oid] ", "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[:int]):bat[:oid] ", "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[:lng]):bat[:oid] ", "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[:sht]):bat[:oid] ", "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:bte):bat[:oid] ", "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:dbl):bat[:oid] ", "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:flt):bat[:oid] ", "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:int):bat[:oid] ", "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:lng):bat[:oid] ", "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:sht):bat[:oid] ", "SQLwindow_bound;", ""
]
+[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:bte]):bat[:oid] ",
"SQLwindow_bound;", "" ]
+[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:dbl]):bat[:oid] ",
"SQLwindow_bound;", "" ]
+[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:flt]):bat[:oid] ",
"SQLwindow_bound;", "" ]
+[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:int]):bat[:oid] ",
"SQLwindow_bound;", "" ]
+[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:lng]):bat[:oid] ",
"SQLwindow_bound;", "" ]
+[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bat[:sht]):bat[:oid] ",
"SQLwindow_bound;", "" ]
+[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:bte):bat[:oid] ",
"SQLwindow_bound;", "" ]
+[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:dbl):bat[:oid] ",
"SQLwindow_bound;", "" ]
+[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:flt):bat[:oid] ",
"SQLwindow_bound;", "" ]
+[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:int):bat[:oid] ",
"SQLwindow_bound;", "" ]
+[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:lng):bat[:oid] ",
"SQLwindow_bound;", "" ]
+[ "batsql", "window_bound", "pattern batsql.window_bound(X_1:bat[:bit],
X_2:bat[:any_1], X_3:int, X_4:int, X_5:int, X_6:sht):bat[:oid] ",
"SQLwindow_bound;", "" ]
[ "batstr", "ascii", "pattern batstr.ascii(X_1:bat[:str]):bat[:int]
", "STRbatAscii;", "" ]
[ "batstr", "ascii", "pattern batstr.ascii(X_1:bat[:str],
X_2:bat[:oid]):bat[:int] ", "STRbatAscii;", "" ]
[ "batstr", "endsWith", "pattern batstr.endsWith(X_1:bat[:str],
X_2:bat[:str]):bat[:bit] ", "STRbatSuffix;", "" ]
@@ -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: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", "avg", "pattern sql.avg(X_1:bte, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):dbl ", "SQLavg;", "" ]
+[ "sql", "avg", "pattern sql.avg(X_1:dbl, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):dbl ", "SQLavg;", "" ]
+[ "sql", "avg", "pattern sql.avg(X_1:flt, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):dbl ", "SQLavg;", "" ]
+[ "sql", "avg", "pattern sql.avg(X_1:int, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):dbl ", "SQLavg;", "" ]
+[ "sql", "avg", "pattern sql.avg(X_1:lng, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):dbl ", "SQLavg;", "" ]
+[ "sql", "avg", "pattern sql.avg(X_1:sht, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):dbl ", "SQLavg;", "" ]
+[ "sql", "avg", "pattern sql.avg(X_1:bte, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):bte ", "SQLavginteger;", "" ]
+[ "sql", "avg", "pattern sql.avg(X_1:int, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):int ", "SQLavginteger;", "" ]
+[ "sql", "avg", "pattern sql.avg(X_1:lng, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):lng ", "SQLavginteger;", "" ]
+[ "sql", "avg", "pattern sql.avg(X_1:sht, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):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:bit, X_4:bit,
X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcorr;", "" ]
-[ "sql", "corr", "pattern sql.corr(X_1:dbl, X_2:dbl, X_3:bit, X_4:bit,
X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcorr;", "" ]
-[ "sql", "corr", "pattern sql.corr(X_1:flt, X_2:flt, X_3:bit, X_4:bit,
X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcorr;", "" ]
-[ "sql", "corr", "pattern sql.corr(X_1:int, X_2:int, X_3:bit, X_4:bit,
X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcorr;", "" ]
-[ "sql", "corr", "pattern sql.corr(X_1:lng, X_2:lng, X_3:bit, X_4:bit,
X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcorr;", "" ]
-[ "sql", "corr", "pattern sql.corr(X_1:sht, X_2:sht, X_3:bit, X_4:bit,
X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcorr;", "" ]
-[ "sql", "count", "pattern sql.count(X_1:any_1, X_2:bit, X_3:bit,
X_4:bit, X_5:int, X_6:lng, X_7:lng):lng ", "SQLcount;", "" ]
-[ "sql", "covariance", "pattern sql.covariance(X_1:bte, X_2:bte,
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcovar_samp;",
"" ]
-[ "sql", "covariance", "pattern sql.covariance(X_1:dbl, X_2:dbl,
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcovar_samp;",
"" ]
-[ "sql", "covariance", "pattern sql.covariance(X_1:flt, X_2:flt,
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcovar_samp;",
"" ]
-[ "sql", "covariance", "pattern sql.covariance(X_1:int, X_2:int,
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcovar_samp;",
"" ]
-[ "sql", "covariance", "pattern sql.covariance(X_1:lng, X_2:lng,
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcovar_samp;",
"" ]
-[ "sql", "covariance", "pattern sql.covariance(X_1:sht, X_2:sht,
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcovar_samp;",
"" ]
-[ "sql", "covariancep", "pattern sql.covariancep(X_1:bte, X_2:bte,
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcovar_pop;", ""
]
-[ "sql", "covariancep", "pattern sql.covariancep(X_1:dbl, X_2:dbl,
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcovar_pop;", ""
]
-[ "sql", "covariancep", "pattern sql.covariancep(X_1:flt, X_2:flt,
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcovar_pop;", ""
]
-[ "sql", "covariancep", "pattern sql.covariancep(X_1:int, X_2:int,
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcovar_pop;", ""
]
-[ "sql", "covariancep", "pattern sql.covariancep(X_1:lng, X_2:lng,
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcovar_pop;", ""
]
-[ "sql", "covariancep", "pattern sql.covariancep(X_1:sht, X_2:sht,
X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):dbl ", "SQLcovar_pop;", ""
]
+[ "sql", "corr", "pattern sql.corr(X_1:bte, X_2:bte, X_3:bit, X_4:bit,
X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcorr;", "" ]
+[ "sql", "corr", "pattern sql.corr(X_1:dbl, X_2:dbl, X_3:bit, X_4:bit,
X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcorr;", "" ]
+[ "sql", "corr", "pattern sql.corr(X_1:flt, X_2:flt, X_3:bit, X_4:bit,
X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcorr;", "" ]
+[ "sql", "corr", "pattern sql.corr(X_1:int, X_2:int, X_3:bit, X_4:bit,
X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcorr;", "" ]
+[ "sql", "corr", "pattern sql.corr(X_1:lng, X_2:lng, X_3:bit, X_4:bit,
X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcorr;", "" ]
+[ "sql", "corr", "pattern sql.corr(X_1:sht, X_2:sht, X_3:bit, X_4:bit,
X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcorr;", "" ]
+[ "sql", "count", "pattern sql.count(X_1:any_1, X_2:bit, X_3:bit,
X_4:bit, X_5:int, X_6:oid, X_7:oid):lng ", "SQLcount;", "" ]
+[ "sql", "covariance", "pattern sql.covariance(X_1:bte, X_2:bte,
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcovar_samp;",
"" ]
+[ "sql", "covariance", "pattern sql.covariance(X_1:dbl, X_2:dbl,
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcovar_samp;",
"" ]
+[ "sql", "covariance", "pattern sql.covariance(X_1:flt, X_2:flt,
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcovar_samp;",
"" ]
+[ "sql", "covariance", "pattern sql.covariance(X_1:int, X_2:int,
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcovar_samp;",
"" ]
+[ "sql", "covariance", "pattern sql.covariance(X_1:lng, X_2:lng,
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcovar_samp;",
"" ]
+[ "sql", "covariance", "pattern sql.covariance(X_1:sht, X_2:sht,
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcovar_samp;",
"" ]
+[ "sql", "covariancep", "pattern sql.covariancep(X_1:bte, X_2:bte,
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcovar_pop;", ""
]
+[ "sql", "covariancep", "pattern sql.covariancep(X_1:dbl, X_2:dbl,
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcovar_pop;", ""
]
+[ "sql", "covariancep", "pattern sql.covariancep(X_1:flt, X_2:flt,
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcovar_pop;", ""
]
+[ "sql", "covariancep", "pattern sql.covariancep(X_1:int, X_2:int,
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcovar_pop;", ""
]
+[ "sql", "covariancep", "pattern sql.covariancep(X_1:lng, X_2:lng,
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcovar_pop;", ""
]
+[ "sql", "covariancep", "pattern sql.covariancep(X_1:sht, X_2:sht,
X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):dbl ", "SQLcovar_pop;", ""
]
[ "sql", "createorderindex", "unsafe pattern
sql.createorderindex(X_1:str, X_2:str, X_3:str):void ",
"sql_createorderindex;", "" ]
[ "sql", "cume_dist", "pattern sql.cume_dist(X_1:any_1, X_2:bit,
X_3:bit):dbl ", "SQLcume_dist;", "" ]
[ "sql", "current_time", "pattern sql.current_time():daytime ",
"SQLcurrent_daytime;", "" ]
@@ -9391,13 +9391,13 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "prelude", "pattern sql.prelude():void ", "SQLprelude;",
"" ]
[ "sql", "prepared_statements", "pattern sql.prepared_statements()
(X_0:bat[:int], X_1:bat[:str], X_2:bat[:int], X_3:bat[:str],
X_4:bat[:timestamp]) ", "SQLsession_prepared_statements;", "" ]
[ "sql", "prepared_statements_args", "pattern
sql.prepared_statements_args() (X_0:bat[:int], X_1:bat[:str], X_2:bat[:int],
X_3:bat[:int], X_4:bat[:bte], X_5:bat[:int], X_6:bat[:str], X_7:bat[:str],
X_8:bat[:str]) ", "SQLsession_prepared_statements_args;", "" ]
-[ "sql", "prod", "pattern sql.prod(X_1:bte, X_2:bit, X_3:bit, X_4:int,
X_5:lng, X_6:lng):lng ", "SQLprod;", "" ]
-[ "sql", "prod", "pattern sql.prod(X_1:dbl, X_2:bit, X_3:bit, X_4:int,
X_5:lng, X_6:lng):dbl ", "SQLprod;", "" ]
-[ "sql", "prod", "pattern sql.prod(X_1:flt, X_2:bit, X_3:bit, X_4:int,
X_5:lng, X_6:lng):dbl ", "SQLprod;", "" ]
-[ "sql", "prod", "pattern sql.prod(X_1:flt, X_2:bit, X_3:bit, X_4:int,
X_5:lng, X_6:lng):flt ", "SQLprod;", "" ]
-[ "sql", "prod", "pattern sql.prod(X_1:int, X_2:bit, X_3:bit, X_4:int,
X_5:lng, X_6:lng):lng ", "SQLprod;", "" ]
-[ "sql", "prod", "pattern sql.prod(X_1:lng, X_2:bit, X_3:bit, X_4:int,
X_5:lng, X_6:lng):lng ", "SQLprod;", "" ]
-[ "sql", "prod", "pattern sql.prod(X_1:sht, X_2:bit, X_3:bit, X_4:int,
X_5:lng, X_6:lng):lng ", "SQLprod;", "" ]
+[ "sql", "prod", "pattern sql.prod(X_1:bte, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):lng ", "SQLprod;", "" ]
+[ "sql", "prod", "pattern sql.prod(X_1:dbl, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):dbl ", "SQLprod;", "" ]
+[ "sql", "prod", "pattern sql.prod(X_1:flt, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):dbl ", "SQLprod;", "" ]
+[ "sql", "prod", "pattern sql.prod(X_1:flt, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):flt ", "SQLprod;", "" ]
+[ "sql", "prod", "pattern sql.prod(X_1:int, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):lng ", "SQLprod;", "" ]
+[ "sql", "prod", "pattern sql.prod(X_1:lng, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):lng ", "SQLprod;", "" ]
+[ "sql", "prod", "pattern sql.prod(X_1:sht, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):lng ", "SQLprod;", "" ]
[ "sql", "project", "command sql.project(X_1:bat[:oid],
X_2:bat[:oid], X_3:bat[:oid]):bat[:oid] ", "BATleftproject;", "" ]
[ "sql", "projectdelta", "command sql.projectdelta(X_1:bat[:oid],
X_2:bat[:any_3], X_3:bat[:oid], X_4:bat[:any_3]):bat[:any_3] ",
"DELTAproject2;", "" ]
[ "sql", "projectdelta", "command sql.projectdelta(X_1:bat[:oid],
X_2:bat[:any_3], X_3:bat[:oid], X_4:bat[:any_3], X_5:bat[:any_3]):bat[:any_3]
", "DELTAproject;", "" ]
@@ -9443,34 +9443,34 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "shutdown", "pattern sql.shutdown(X_1:sht):str ",
"SQLshutdown_wrap;", "" ]
[ "sql", "shutdown", "pattern sql.shutdown(X_1:sht, X_2:bit):str ",
"SQLshutdown_wrap;", "" ]
[ "sql", "sql_variables", "pattern sql.sql_variables()
(X_0:bat[:str], X_1:bat[:str], X_2:bat[:str], X_3:bat[:str]) ",
"sql_variables;", "" ]
-[ "sql", "stdev", "pattern sql.stdev(X_1:bte, X_2:bit, X_3:bit,
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_samp;", "" ]
-[ "sql", "stdev", "pattern sql.stdev(X_1:dbl, X_2:bit, X_3:bit,
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_samp;", "" ]
-[ "sql", "stdev", "pattern sql.stdev(X_1:flt, X_2:bit, X_3:bit,
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_samp;", "" ]
-[ "sql", "stdev", "pattern sql.stdev(X_1:int, X_2:bit, X_3:bit,
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_samp;", "" ]
-[ "sql", "stdev", "pattern sql.stdev(X_1:lng, X_2:bit, X_3:bit,
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_samp;", "" ]
-[ "sql", "stdev", "pattern sql.stdev(X_1:sht, X_2:bit, X_3:bit,
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_samp;", "" ]
-[ "sql", "stdevp", "pattern sql.stdevp(X_1:bte, X_2:bit, X_3:bit,
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_pop;", "" ]
-[ "sql", "stdevp", "pattern sql.stdevp(X_1:dbl, X_2:bit, X_3:bit,
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_pop;", "" ]
-[ "sql", "stdevp", "pattern sql.stdevp(X_1:flt, X_2:bit, X_3:bit,
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_pop;", "" ]
-[ "sql", "stdevp", "pattern sql.stdevp(X_1:int, X_2:bit, X_3:bit,
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_pop;", "" ]
-[ "sql", "stdevp", "pattern sql.stdevp(X_1:lng, X_2:bit, X_3:bit,
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_pop;", "" ]
-[ "sql", "stdevp", "pattern sql.stdevp(X_1:sht, X_2:bit, X_3:bit,
X_4:int, X_5:lng, X_6:lng):dbl ", "SQLstddev_pop;", "" ]
+[ "sql", "stdev", "pattern sql.stdev(X_1:bte, X_2:bit, X_3:bit,
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_samp;", "" ]
+[ "sql", "stdev", "pattern sql.stdev(X_1:dbl, X_2:bit, X_3:bit,
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_samp;", "" ]
+[ "sql", "stdev", "pattern sql.stdev(X_1:flt, X_2:bit, X_3:bit,
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_samp;", "" ]
+[ "sql", "stdev", "pattern sql.stdev(X_1:int, X_2:bit, X_3:bit,
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_samp;", "" ]
+[ "sql", "stdev", "pattern sql.stdev(X_1:lng, X_2:bit, X_3:bit,
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_samp;", "" ]
+[ "sql", "stdev", "pattern sql.stdev(X_1:sht, X_2:bit, X_3:bit,
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_samp;", "" ]
+[ "sql", "stdevp", "pattern sql.stdevp(X_1:bte, X_2:bit, X_3:bit,
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_pop;", "" ]
+[ "sql", "stdevp", "pattern sql.stdevp(X_1:dbl, X_2:bit, X_3:bit,
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_pop;", "" ]
+[ "sql", "stdevp", "pattern sql.stdevp(X_1:flt, X_2:bit, X_3:bit,
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_pop;", "" ]
+[ "sql", "stdevp", "pattern sql.stdevp(X_1:int, X_2:bit, X_3:bit,
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_pop;", "" ]
+[ "sql", "stdevp", "pattern sql.stdevp(X_1:lng, X_2:bit, X_3:bit,
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_pop;", "" ]
+[ "sql", "stdevp", "pattern sql.stdevp(X_1:sht, X_2:bit, X_3:bit,
X_4:int, X_5:oid, X_6:oid):dbl ", "SQLstddev_pop;", "" ]
[ "sql", "storage", "pattern sql.storage() (X_0:bat[:str],
X_1:bat[:str], X_2:bat[:str], X_3:bat[:str], X_4:bat[:str], X_5:bat[:str],
X_6:bat[:lng], X_7:bat[:int], X_8:bat[:lng], X_9:bat[:lng], X_10:bat[:lng],
X_11:bat[:bit], X_12:bat[:lng], X_13:bat[:bit], X_14:bat[:bit], X_15:bat[:bit],
X_16:bat[:lng]) ", "sql_storage;", "" ]
[ "sql", "storage", "pattern sql.storage(X_17:str) (X_0:bat[:str],
X_1:bat[:str], X_2:bat[:str], X_3:bat[:str], X_4:bat[:str], X_5:bat[:str],
X_6:bat[:lng], X_7:bat[:int], X_8:bat[:lng], X_9:bat[:lng], X_10:bat[:lng],
X_11:bat[:bit], X_12:bat[:lng], X_13:bat[:bit], X_14:bat[:bit], X_15:bat[:bit],
X_16:bat[:lng]) ", "sql_storage;", "" ]
[ "sql", "storage", "pattern sql.storage(X_17:str, X_18:str)
(X_0:bat[:str], X_1:bat[:str], X_2:bat[:str], X_3:bat[:str], X_4:bat[:str],
X_5:bat[:str], X_6:bat[:lng], X_7:bat[:int], X_8:bat[:lng], X_9:bat[:lng],
X_10:bat[:lng], X_11:bat[:bit], X_12:bat[:lng], X_13:bat[:bit], X_14:bat[:bit],
X_15:bat[:bit], X_16:bat[:lng]) ", "sql_storage;", "" ]
[ "sql", "storage", "pattern sql.storage(X_17:str, X_18:str,
X_19:str) (X_0:bat[:str], X_1:bat[:str], X_2:bat[:str], X_3:bat[:str],
X_4:bat[:str], X_5:bat[:str], X_6:bat[:lng], X_7:bat[:int], X_8:bat[:lng],
X_9:bat[:lng], X_10:bat[:lng], X_11:bat[:bit], X_12:bat[:lng], X_13:bat[:bit],
X_14:bat[:bit], X_15:bat[:bit], X_16:bat[:lng]) ", "sql_storage;", "" ]
-[ "sql", "str_group_concat", "pattern sql.str_group_concat(X_1:str,
X_2:bit, X_3:bit, X_4:int, X_5:lng, X_6:lng):str ", "SQLstrgroup_concat;",
"" ]
-[ "sql", "str_group_concat", "pattern sql.str_group_concat(X_1:str,
X_2:str, X_3:bit, X_4:bit, X_5:int, X_6:lng, X_7:lng):str ",
"SQLstrgroup_concat;", "" ]
+[ "sql", "str_group_concat", "pattern sql.str_group_concat(X_1:str,
X_2:bit, X_3:bit, X_4:int, X_5:oid, X_6:oid):str ", "SQLstrgroup_concat;",
"" ]
+[ "sql", "str_group_concat", "pattern sql.str_group_concat(X_1:str,
X_2:str, X_3:bit, X_4:bit, X_5:int, X_6:oid, X_7:oid):str ",
"SQLstrgroup_concat;", "" ]
[ "sql", "strings", "command sql.strings(X_1:str):str ",
"STRstrings;", "" ]
[ "sql", "subdelta", "command sql.subdelta(X_1:bat[:oid],
X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:oid]):bat[:oid] ", "DELTAsub2;", ""
]
[ "sql", "subdelta", "command sql.subdelta(X_1:bat[:oid],
X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:oid]):bat[:oid] ",
"DELTAsub;", "" ]
-[ "sql", "sum", "pattern sql.sum(X_1:bte, X_2:bit, X_3:bit, X_4:int,
X_5:lng, X_6:lng):lng ", "SQLsum;", "" ]
-[ "sql", "sum", "pattern sql.sum(X_1:dbl, X_2:bit, X_3:bit, X_4:int,
X_5:lng, X_6:lng):dbl ", "SQLsum;", "" ]
-[ "sql", "sum", "pattern sql.sum(X_1:flt, X_2:bit, X_3:bit, X_4:int,
X_5:lng, X_6:lng):dbl ", "SQLsum;", "" ]
-[ "sql", "sum", "pattern sql.sum(X_1:flt, X_2:bit, X_3:bit, X_4:int,
X_5:lng, X_6:lng):flt ", "SQLsum;", "" ]
-[ "sql", "sum", "pattern sql.sum(X_1:int, X_2:bit, X_3:bit, X_4:int,
X_5:lng, X_6:lng):lng ", "SQLsum;", "" ]
-[ "sql", "sum", "pattern sql.sum(X_1:lng, X_2:bit, X_3:bit, X_4:int,
X_5:lng, X_6:lng):lng ", "SQLsum;", "" ]
-[ "sql", "sum", "pattern sql.sum(X_1:sht, X_2:bit, X_3:bit, X_4:int,
X_5:lng, X_6:lng):lng ", "SQLsum;", "" ]
+[ "sql", "sum", "pattern sql.sum(X_1:bte, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):lng ", "SQLsum;", "" ]
+[ "sql", "sum", "pattern sql.sum(X_1:dbl, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):dbl ", "SQLsum;", "" ]
+[ "sql", "sum", "pattern sql.sum(X_1:flt, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):dbl ", "SQLsum;", "" ]
+[ "sql", "sum", "pattern sql.sum(X_1:flt, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):flt ", "SQLsum;", "" ]
+[ "sql", "sum", "pattern sql.sum(X_1:int, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):lng ", "SQLsum;", "" ]
+[ "sql", "sum", "pattern sql.sum(X_1:lng, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):lng ", "SQLsum;", "" ]
+[ "sql", "sum", "pattern sql.sum(X_1:sht, X_2:bit, X_3:bit, X_4:int,
X_5:oid, X_6:oid):lng ", "SQLsum;", "" ]
[ "sql", "suspend_log_flushing", "unsafe command
sql.suspend_log_flushing():void ", "SQLsuspend_log_flushing;", ""
]
[ "sql", "tid", "pattern sql.tid(X_1:int, X_2:str, X_3:str):bat[:oid]
", "SQLtid;", "" ]
[ "sql", "tid", "pattern sql.tid(X_1:int, X_2:str, X_3:str, X_4:int,
X_5:int):bat[:oid] ", "SQLtid;", "" ]
@@ -9485,30 +9485,30 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "update_schemas", "unsafe pattern
sql.update_schemas():void ", "SYSupdate_schemas;", "" ]
[ "sql", "update_tables", "unsafe pattern
sql.update_tables():void ", "SYSupdate_tables;", "" ]
[ "sql", "vacuum", "unsafe pattern sql.vacuum(X_1:str,
X_2:str):void ", "SQLvacuum;", "" ]
-[ "sql", "variance", "pattern sql.variance(X_1:bte, X_2:bit,
X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLvar_samp;", "" ]
-[ "sql", "variance", "pattern sql.variance(X_1:dbl, X_2:bit,
X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLvar_samp;", "" ]
-[ "sql", "variance", "pattern sql.variance(X_1:flt, X_2:bit,
X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLvar_samp;", "" ]
-[ "sql", "variance", "pattern sql.variance(X_1:int, X_2:bit,
X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLvar_samp;", "" ]
-[ "sql", "variance", "pattern sql.variance(X_1:lng, X_2:bit,
X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLvar_samp;", "" ]
-[ "sql", "variance", "pattern sql.variance(X_1:sht, X_2:bit,
X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLvar_samp;", "" ]
-[ "sql", "variancep", "pattern sql.variancep(X_1:bte, X_2:bit,
X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLvar_pop;", "" ]
-[ "sql", "variancep", "pattern sql.variancep(X_1:dbl, X_2:bit,
X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLvar_pop;", "" ]
-[ "sql", "variancep", "pattern sql.variancep(X_1:flt, X_2:bit,
X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLvar_pop;", "" ]
-[ "sql", "variancep", "pattern sql.variancep(X_1:int, X_2:bit,
X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLvar_pop;", "" ]
-[ "sql", "variancep", "pattern sql.variancep(X_1:lng, X_2:bit,
X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLvar_pop;", "" ]
-[ "sql", "variancep", "pattern sql.variancep(X_1:sht, X_2:bit,
X_3:bit, X_4:int, X_5:lng, X_6:lng):dbl ", "SQLvar_pop;", "" ]
-[ "sql", "window_bound", "pattern sql.window_bound(X_1:any_1, X_2:int,
X_3:int, X_4:int, X_5:bte):lng ", "SQLwindow_bound;", "" ]
-[ "sql", "window_bound", "pattern sql.window_bound(X_1:any_1, X_2:int,
X_3:int, X_4:int, X_5:dbl):lng ", "SQLwindow_bound;", "" ]
-[ "sql", "window_bound", "pattern sql.window_bound(X_1:any_1, X_2:int,
X_3:int, X_4:int, X_5:flt):lng ", "SQLwindow_bound;", "" ]
-[ "sql", "window_bound", "pattern sql.window_bound(X_1:any_1, X_2:int,
X_3:int, X_4:int, X_5:int):lng ", "SQLwindow_bound;", "" ]
-[ "sql", "window_bound", "pattern sql.window_bound(X_1:any_1, X_2:int,
X_3:int, X_4:int, X_5:lng):lng ", "SQLwindow_bound;", "" ]
-[ "sql", "window_bound", "pattern sql.window_bound(X_1:any_1, X_2:int,
X_3:int, X_4:int, X_5:sht):lng ", "SQLwindow_bound;", "" ]
-[ "sql", "window_bound", "pattern sql.window_bound(X_1:bit, X_2:any_1,
X_3:int, X_4:int, X_5:int, X_6:bte):lng ", "SQLwindow_bound;", ""
]
-[ "sql", "window_bound", "pattern sql.window_bound(X_1:bit, X_2:any_1,
X_3:int, X_4:int, X_5:int, X_6:dbl):lng ", "SQLwindow_bound;", ""
]
-[ "sql", "window_bound", "pattern sql.window_bound(X_1:bit, X_2:any_1,
X_3:int, X_4:int, X_5:int, X_6:flt):lng ", "SQLwindow_bound;", ""
]
-[ "sql", "window_bound", "pattern sql.window_bound(X_1:bit, X_2:any_1,
X_3:int, X_4:int, X_5:int, X_6:int):lng ", "SQLwindow_bound;", ""
]
-[ "sql", "window_bound", "pattern sql.window_bound(X_1:bit, X_2:any_1,
X_3:int, X_4:int, X_5:int, X_6:lng):lng ", "SQLwindow_bound;", ""
]
-[ "sql", "window_bound", "pattern sql.window_bound(X_1:bit, X_2:any_1,
X_3:int, X_4:int, X_5:int, X_6:sht):lng ", "SQLwindow_bound;", ""
]
+[ "sql", "variance", "pattern sql.variance(X_1:bte, X_2:bit,
X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ", "SQLvar_samp;", "" ]
+[ "sql", "variance", "pattern sql.variance(X_1:dbl, X_2:bit,
X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ", "SQLvar_samp;", "" ]
+[ "sql", "variance", "pattern sql.variance(X_1:flt, X_2:bit,
X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ", "SQLvar_samp;", "" ]
+[ "sql", "variance", "pattern sql.variance(X_1:int, X_2:bit,
X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ", "SQLvar_samp;", "" ]
+[ "sql", "variance", "pattern sql.variance(X_1:lng, X_2:bit,
X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ", "SQLvar_samp;", "" ]
+[ "sql", "variance", "pattern sql.variance(X_1:sht, X_2:bit,
X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ", "SQLvar_samp;", "" ]
+[ "sql", "variancep", "pattern sql.variancep(X_1:bte, X_2:bit,
X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ", "SQLvar_pop;", "" ]
+[ "sql", "variancep", "pattern sql.variancep(X_1:dbl, X_2:bit,
X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ", "SQLvar_pop;", "" ]
+[ "sql", "variancep", "pattern sql.variancep(X_1:flt, X_2:bit,
X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ", "SQLvar_pop;", "" ]
+[ "sql", "variancep", "pattern sql.variancep(X_1:int, X_2:bit,
X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ", "SQLvar_pop;", "" ]
+[ "sql", "variancep", "pattern sql.variancep(X_1:lng, X_2:bit,
X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ", "SQLvar_pop;", "" ]
+[ "sql", "variancep", "pattern sql.variancep(X_1:sht, X_2:bit,
X_3:bit, X_4:int, X_5:oid, X_6:oid):dbl ", "SQLvar_pop;", "" ]
+[ "sql", "window_bound", "pattern sql.window_bound(X_1:any_1, X_2:int,
X_3:int, X_4:int, X_5:bte):oid ", "SQLwindow_bound;", "" ]
+[ "sql", "window_bound", "pattern sql.window_bound(X_1:any_1, X_2:int,
X_3:int, X_4:int, X_5:dbl):oid ", "SQLwindow_bound;", "" ]
+[ "sql", "window_bound", "pattern sql.window_bound(X_1:any_1, X_2:int,
X_3:int, X_4:int, X_5:flt):oid ", "SQLwindow_bound;", "" ]
+[ "sql", "window_bound", "pattern sql.window_bound(X_1:any_1, X_2:int,
X_3:int, X_4:int, X_5:int):oid ", "SQLwindow_bound;", "" ]
+[ "sql", "window_bound", "pattern sql.window_bound(X_1:any_1, X_2:int,
X_3:int, X_4:int, X_5:lng):oid ", "SQLwindow_bound;", "" ]
+[ "sql", "window_bound", "pattern sql.window_bound(X_1:any_1, X_2:int,
X_3:int, X_4:int, X_5:sht):oid ", "SQLwindow_bound;", "" ]
+[ "sql", "window_bound", "pattern sql.window_bound(X_1:bit, X_2:any_1,
X_3:int, X_4:int, X_5:int, X_6:bte):oid ", "SQLwindow_bound;", ""
]
+[ "sql", "window_bound", "pattern sql.window_bound(X_1:bit, X_2:any_1,
X_3:int, X_4:int, X_5:int, X_6:dbl):oid ", "SQLwindow_bound;", ""
]
+[ "sql", "window_bound", "pattern sql.window_bound(X_1:bit, X_2:any_1,
X_3:int, X_4:int, X_5:int, X_6:flt):oid ", "SQLwindow_bound;", ""
]
+[ "sql", "window_bound", "pattern sql.window_bound(X_1:bit, X_2:any_1,
X_3:int, X_4:int, X_5:int, X_6:int):oid ", "SQLwindow_bound;", ""
]
+[ "sql", "window_bound", "pattern sql.window_bound(X_1:bit, X_2:any_1,
X_3:int, X_4:int, X_5:int, X_6:lng):oid ", "SQLwindow_bound;", ""
]
+[ "sql", "window_bound", "pattern sql.window_bound(X_1:bit, X_2:any_1,
X_3:int, X_4:int, X_5:int, X_6:sht):oid ", "SQLwindow_bound;", ""
]
[ "sqlcatalog", "alter_add_range_partition", "pattern
sqlcatalog.alter_add_range_partition(X_1:str, X_2:str, X_3:str, X_4:str,
X_5:any_1, X_6:any_1, X_7:bit, X_8:int):void ",
"SQLalter_add_range_partition;", "" ]
[ "sqlcatalog", "alter_add_table", "pattern
sqlcatalog.alter_add_table(X_1:str, X_2:str, X_3:str, X_4:str, X_5:int):void ",
"SQLalter_add_table;", "" ]
[ "sqlcatalog", "alter_add_value_partition", "pattern
sqlcatalog.alter_add_value_partition(X_1:str, X_2:str, X_3:str, X_4:str,
X_5:bit, X_6:int):void ", "SQLalter_add_value_partition;", "" ]
diff --git a/sql/test/sys-schema/Tests/systemfunctions.stable.out
b/sql/test/sys-schema/Tests/systemfunctions.stable.out
--- a/sql/test/sys-schema/Tests/systemfunctions.stable.out
+++ b/sql/test/sys-schema/Tests/systemfunctions.stable.out
@@ -3654,169 +3654,169 @@ stdout of test 'systemfunctions` in dire
[ "sys", "week", 1, "date", "" ]
[ "sys", "weekofyear", 0, "int", "weekofyear" ]
[ "sys", "weekofyear", 1, "date", "" ]
-[ "sys", "window_bound", 0, "bigint", "window_bound" ]
+[ "sys", "window_bound", 0, "oid", "window_bound" ]
[ "sys", "window_bound", 1, "any", "" ]
[ "sys", "window_bound", 2, "int", "" ]
[ "sys", "window_bound", 3, "int", "" ]
[ "sys", "window_bound", 4, "int", "" ]
[ "sys", "window_bound", 5, "tinyint", "" ]
-[ "sys", "window_bound", 0, "bigint", "window_bound" ]
+[ "sys", "window_bound", 0, "oid", "window_bound" ]
[ "sys", "window_bound", 1, "boolean", "" ]
[ "sys", "window_bound", 2, "any", "" ]
[ "sys", "window_bound", 3, "int", "" ]
[ "sys", "window_bound", 4, "int", "" ]
[ "sys", "window_bound", 5, "int", "" ]
[ "sys", "window_bound", 6, "tinyint", "" ]
-[ "sys", "window_bound", 0, "bigint", "window_bound" ]
+[ "sys", "window_bound", 0, "oid", "window_bound" ]
[ "sys", "window_bound", 1, "any", "" ]
[ "sys", "window_bound", 2, "int", "" ]
[ "sys", "window_bound", 3, "int", "" ]
[ "sys", "window_bound", 4, "int", "" ]
[ "sys", "window_bound", 5, "smallint", "" ]
-[ "sys", "window_bound", 0, "bigint", "window_bound" ]
+[ "sys", "window_bound", 0, "oid", "window_bound" ]
[ "sys", "window_bound", 1, "boolean", "" ]
[ "sys", "window_bound", 2, "any", "" ]
[ "sys", "window_bound", 3, "int", "" ]
[ "sys", "window_bound", 4, "int", "" ]
[ "sys", "window_bound", 5, "int", "" ]
[ "sys", "window_bound", 6, "smallint", "" ]
-[ "sys", "window_bound", 0, "bigint", "window_bound" ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
