Changeset: 537096c2d61e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=537096c2d61e
Added Files:
sql/test/analytics/Tests/analytics20.test
Modified Files:
sql/server/rel_optimizer.c
sql/test/analytics/Tests/analytics00.test
sql/test/analytics/Tests/analytics01.test
sql/test/analytics/Tests/analytics02.test
sql/test/analytics/Tests/analytics03.test
sql/test/analytics/Tests/analytics04.test
sql/test/analytics/Tests/analytics05.test
sql/test/analytics/Tests/analytics06.test
sql/test/analytics/Tests/analytics07.test
sql/test/analytics/Tests/analytics08.test
sql/test/analytics/Tests/analytics09.test
sql/test/analytics/Tests/analytics10.test
sql/test/analytics/Tests/analytics11.test
sql/test/analytics/Tests/analytics12.test
sql/test/analytics/Tests/analytics13.test
sql/test/analytics/Tests/analytics14.test
sql/test/analytics/Tests/analytics15.test
sql/test/analytics/Tests/analytics16.test
sql/test/analytics/Tests/analytics17.test
sql/test/analytics/Tests/analytics18.test
sql/test/analytics/Tests/analytics19.test
testing/Mtest.py.in
Branch: mtest
Log Message:
Merge with default branch.
diffs (truncated from 148535 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;", "" ]
@@ -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;", "" ]
@@ -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,66 +6424,66 @@ 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", "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", "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[: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;",
"" ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
