Changeset: 1e8587b1600e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1e8587b1600e
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
clients/Tests/exports.stable.out
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: statistics-analytics
Log Message:
Approved output
diffs (truncated from 2897 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
@@ -8967,7 +8967,70 @@ stdout of test 'MAL-signatures` in direc
[ "batsql", "avg", "pattern batsql.avg(b:bat[:int], s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLavg;", "return the average of groups" ]
[ "batsql", "avg", "pattern batsql.avg(b:bat[:lng], s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLavg;", "return the average of groups" ]
[ "batsql", "avg", "pattern batsql.avg(b:bat[:sht], s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLavg;", "return the average of groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:bat[:bte], c:bat[:bte],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcorr;", "return the
correlation value of groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:bat[:bte], c:bte, s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLcorr;", "return the correlation value of
groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:bat[:dbl], c:bat[:dbl],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcorr;", "return the
correlation value of groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:bat[:dbl], c:dbl, s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLcorr;", "return the correlation value of
groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:bat[:flt], c:bat[:flt],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcorr;", "return the
correlation value of groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:bat[:flt], c:flt, s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLcorr;", "return the correlation value of
groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:bat[:hge], c:bat[:hge],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcorr;", "return the
correlation value of groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:bat[:hge], c:hge, s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLcorr;", "return the correlation value of
groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:bat[:int], c:bat[:int],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcorr;", "return the
correlation value of groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:bat[:int], c:int, s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLcorr;", "return the correlation value of
groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:bat[:lng], c:bat[:lng],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcorr;", "return the
correlation value of groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:bat[:lng], c:lng, s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLcorr;", "return the correlation value of
groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:bat[:sht], c:bat[:sht],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcorr;", "return the
correlation value of groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:bat[:sht], c:sht, s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLcorr;", "return the correlation value of
groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:bte, c:bat[:bte], s:lng,
e:lng):bat[:dbl] ", "SQLcorr;", "return the correlation value of
groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:dbl, c:bat[:dbl], s:lng,
e:lng):bat[:dbl] ", "SQLcorr;", "return the correlation value of
groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:flt, c:bat[:flt], s:lng,
e:lng):bat[:dbl] ", "SQLcorr;", "return the correlation value of
groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:hge, c:bat[:hge], s:lng,
e:lng):bat[:dbl] ", "SQLcorr;", "return the correlation value of
groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:int, c:bat[:int], s:lng,
e:lng):bat[:dbl] ", "SQLcorr;", "return the correlation value of
groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:lng, c:bat[:lng], s:lng,
e:lng):bat[:dbl] ", "SQLcorr;", "return the correlation value of
groups" ]
+[ "batsql", "corr", "pattern batsql.corr(b:sht, c:bat[:sht], s:lng,
e:lng):bat[:dbl] ", "SQLcorr;", "return the correlation value of
groups" ]
[ "batsql", "count", "pattern batsql.count(b:bat[:any_1],
ignils:bit, s:bat[:lng], e:bat[:lng]):bat[:lng] ", "SQLcount;", "return
count of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:bat[:bte],
c:bat[:bte], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;",
"return the covariance sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:bat[:bte], c:bte,
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "return the
covariance sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:bat[:dbl],
c:bat[:dbl], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;",
"return the covariance sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:bat[:dbl], c:dbl,
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "return the
covariance sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:bat[:flt],
c:bat[:flt], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;",
"return the covariance sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:bat[:flt], c:flt,
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "return the
covariance sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:bat[:hge],
c:bat[:hge], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;",
"return the covariance sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:bat[:hge], c:hge,
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "return the
covariance sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:bat[:int],
c:bat[:int], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;",
"return the covariance sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:bat[:int], c:int,
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "return the
covariance sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:bat[:lng],
c:bat[:lng], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;",
"return the covariance sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:bat[:lng], c:lng,
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "return the
covariance sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:bat[:sht],
c:bat[:sht], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;",
"return the covariance sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:bat[:sht], c:sht,
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_samp;", "return the
covariance sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:bte, c:bat[:bte],
s:lng, e:lng):bat[:dbl] ", "SQLcovar_samp;", "return the covariance
sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:dbl, c:bat[:dbl],
s:lng, e:lng):bat[:dbl] ", "SQLcovar_samp;", "return the covariance
sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:flt, c:bat[:flt],
s:lng, e:lng):bat[:dbl] ", "SQLcovar_samp;", "return the covariance
sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:hge, c:bat[:hge],
s:lng, e:lng):bat[:dbl] ", "SQLcovar_samp;", "return the covariance
sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:int, c:bat[:int],
s:lng, e:lng):bat[:dbl] ", "SQLcovar_samp;", "return the covariance
sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:lng, c:bat[:lng],
s:lng, e:lng):bat[:dbl] ", "SQLcovar_samp;", "return the covariance
sample value of groups" ]
+[ "batsql", "covariance", "pattern batsql.covariance(b:sht, c:bat[:sht],
s:lng, e:lng):bat[:dbl] ", "SQLcovar_samp;", "return the covariance
sample value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:bat[:bte],
c:bat[:bte], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;",
"return the covariance population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:bat[:bte], c:bte,
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "return the
covariance population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:bat[:dbl],
c:bat[:dbl], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;",
"return the covariance population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:bat[:dbl], c:dbl,
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "return the
covariance population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:bat[:flt],
c:bat[:flt], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;",
"return the covariance population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:bat[:flt], c:flt,
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "return the
covariance population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:bat[:hge],
c:bat[:hge], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;",
"return the covariance population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:bat[:hge], c:hge,
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "return the
covariance population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:bat[:int],
c:bat[:int], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;",
"return the covariance population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:bat[:int], c:int,
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "return the
covariance population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:bat[:lng],
c:bat[:lng], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;",
"return the covariance population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:bat[:lng], c:lng,
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "return the
covariance population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:bat[:sht],
c:bat[:sht], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;",
"return the covariance population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:bat[:sht], c:sht,
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLcovar_pop;", "return the
covariance population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:bte, c:bat[:bte],
s:lng, e:lng):bat[:dbl] ", "SQLcovar_pop;", "return the covariance
population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:dbl, c:bat[:dbl],
s:lng, e:lng):bat[:dbl] ", "SQLcovar_pop;", "return the covariance
population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:flt, c:bat[:flt],
s:lng, e:lng):bat[:dbl] ", "SQLcovar_pop;", "return the covariance
population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:hge, c:bat[:hge],
s:lng, e:lng):bat[:dbl] ", "SQLcovar_pop;", "return the covariance
population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:int, c:bat[:int],
s:lng, e:lng):bat[:dbl] ", "SQLcovar_pop;", "return the covariance
population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:lng, c:bat[:lng],
s:lng, e:lng):bat[:dbl] ", "SQLcovar_pop;", "return the covariance
population value of groups" ]
+[ "batsql", "covariancep", "pattern batsql.covariancep(b:sht, c:bat[:sht],
s:lng, e:lng):bat[:dbl] ", "SQLcovar_pop;", "return the covariance
population value of groups" ]
[ "batsql", "cume_dist", "pattern batsql.cume_dist(b:bat[:any_1],
p:any_2, o:any_3):bat[:dbl] ", "SQLcume_dist;", "return the accumulated
distribution of the number of rows per group to the total number of partition
rows" ]
[ "batsql", "dec_round", "command batsql.dec_round(v:bat[:bte],
r:bte):bat[:bte] ", "bte_bat_dec_round_wrap;", "round off the value v
to nearests multiple of r" ]
[ "batsql", "dec_round", "command batsql.dec_round(v:bat[:dbl],
r:dbl):bat[:dbl] ", "dbl_bat_dec_round_wrap;", "round off the value v
to nearests multiple of r" ]
@@ -8984,6 +9047,10 @@ stdout of test 'MAL-signatures` in direc
[ "batsql", "get_value", "pattern batsql.get_value(sname:bat[:str],
sequence:bat[:str]):bat[:lng] ", "mvc_bat_get_value;", "return the
current value of sequences" ]
[ "batsql", "get_value", "pattern batsql.get_value(sname:bat[:str],
sequence:str):bat[:lng] ", "mvc_bat_get_value;", "return the current value
of the sequence" ]
[ "batsql", "get_value", "pattern batsql.get_value(sname:str,
sequence:bat[:str]):bat[:lng] ", "mvc_bat_get_value;", "return the current
value of sequences" ]
+[ "batsql", "lag", "pattern batsql.lag(b:any_1, l:any_2, d:bat[:any_1],
p:any_3, o:any_4):bat[:any_1] ", "SQLlag;", "return the value in the
previous 'l' row in the partition or 'd' if non existent" ]
+[ "batsql", "lag", "pattern batsql.lag(b:any_1, l:bat[:any_2], d:any_1,
p:any_3, o:any_4):bat[:any_1] ", "SQLlag;", "return the value in the
previous 'l' row in the partition or 'd' if non existent" ]
+[ "batsql", "lag", "pattern batsql.lag(b:any_1, l:bat[:any_2],
d:bat[:any_1], p:any_3, o:any_4):bat[:any_1] ", "SQLlag;", "return the
value in the previous 'l' row in the partition or 'd' if non existent" ]
+[ "batsql", "lag", "pattern batsql.lag(b:any_1, l:bat[:any_2], p:any_3,
o:any_4):bat[:any_1] ", "SQLlag;", "return the value in the previous
'l' row in the partition or NULL if non existent" ]
[ "batsql", "lag", "pattern batsql.lag(b:bat[:any_1], l:any_2, d:any_1,
p:any_3, o:any_4):bat[:any_1] ", "SQLlag;", "return the value in the
previous 'l' row in the partition or 'd' if non existent" ]
[ "batsql", "lag", "pattern batsql.lag(b:bat[:any_1], l:any_2,
d:bat[:any_1], p:any_3, o:any_4):bat[:any_1] ", "SQLlag;", "return the
value in the previous 'l' row in the partition or 'd' if non existent" ]
[ "batsql", "lag", "pattern batsql.lag(b:bat[:any_1], l:any_2, p:any_3,
o:any_4):bat[:any_1] ", "SQLlag;", "return the value in the previous
'l' row in the partition or NULL if non existent" ]
@@ -8992,6 +9059,10 @@ stdout of test 'MAL-signatures` in direc
[ "batsql", "lag", "pattern batsql.lag(b:bat[:any_1], l:bat[:any_2],
p:any_3, o:any_4):bat[:any_1] ", "SQLlag;", "return the value in the
previous 'l' row in the partition or NULL if non existent" ]
[ "batsql", "lag", "pattern batsql.lag(b:bat[:any_1], p:any_3,
o:any_4):bat[:any_1] ", "SQLlag;", "return the value in the previous
row in the partition or NULL if non existent" ]
[ "batsql", "last_value", "pattern batsql.last_value(b:bat[:any_1],
s:bat[:lng], e:bat[:lng]):bat[:any_1] ", "SQLlast_value;", "return
the last value of groups" ]
+[ "batsql", "lead", "pattern batsql.lead(b:any_1, l:any_2, d:bat[:any_1],
p:any_3, o:any_4):bat[:any_1] ", "SQLlead;", "return the value in the next
'l' row in the partition or 'd' if non existent" ]
+[ "batsql", "lead", "pattern batsql.lead(b:any_1, l:bat[:any_2], d:any_1,
p:any_3, o:any_4):bat[:any_1] ", "SQLlead;", "return the value in the next
'l' row in the partition or 'd' if non existent" ]
+[ "batsql", "lead", "pattern batsql.lead(b:any_1, l:bat[:any_2],
d:bat[:any_1], p:any_3, o:any_4):bat[:any_1] ", "SQLlead;", "return the
value in the next 'l' row in the partition or 'd' if non existent" ]
+[ "batsql", "lead", "pattern batsql.lead(b:any_1, l:bat[:any_2], p:any_3,
o:any_4):bat[:any_1] ", "SQLlead;", "return the value in the next 'l' row
in the partition or NULL if non existent" ]
[ "batsql", "lead", "pattern batsql.lead(b:bat[:any_1], l:any_2, d:any_1,
p:any_3, o:any_4):bat[:any_1] ", "SQLlead;", "return the value in the next
'l' row in the partition or 'd' if non existent" ]
[ "batsql", "lead", "pattern batsql.lead(b:bat[:any_1], l:any_2,
d:bat[:any_1], p:any_3, o:any_4):bat[:any_1] ", "SQLlead;", "return the
value in the next 'l' row in the partition or 'd' if non existent" ]
[ "batsql", "lead", "pattern batsql.lead(b:bat[:any_1], l:any_2, p:any_3,
o:any_4):bat[:any_1] ", "SQLlead;", "return the value in the next 'l' row
in the partition or NULL if non existent" ]
@@ -9004,8 +9075,10 @@ stdout of test 'MAL-signatures` in direc
[ "batsql", "next_value", "pattern batsql.next_value(sname:bat[:str],
sequence:bat[:str]):bat[:lng] ", "mvc_bat_next_value;", "return the next
value of sequences" ]
[ "batsql", "next_value", "pattern batsql.next_value(sname:bat[:str],
sequence:str):bat[:lng] ", "mvc_bat_next_value;", "return the next value of
the sequence" ]
[ "batsql", "next_value", "pattern batsql.next_value(sname:str,
sequence:bat[:str]):bat[:lng] ", "mvc_bat_next_value;", "return the next
value of sequences" ]
+[ "batsql", "nth_value", "pattern batsql.nth_value(b:any_1,
n:bat[:any_2], s:lng, e:lng):bat[:any_1] ", "SQLnth_value;", "return
the nth value of each group" ]
[ "batsql", "nth_value", "pattern batsql.nth_value(b:bat[:any_1],
n:any_2, s:bat[:lng], e:bat[:lng]):bat[:any_1] ", "SQLnth_value;",
"return the nth value of each group" ]
[ "batsql", "nth_value", "pattern batsql.nth_value(b:bat[:any_1],
n:bat[:any_2], s:bat[:lng], e:bat[:lng]):bat[:any_1] ", "SQLnth_value;",
"return the nth value of each group" ]
+[ "batsql", "ntile", "pattern batsql.ntile(b:any_1, n:bat[:any_2],
p:any_3, o:any_4):bat[:any_2] ", "SQLntile;", "return the groups divided as
equally as possible" ]
[ "batsql", "ntile", "pattern batsql.ntile(b:bat[:any_1], n:any_2,
p:any_3, o:any_4):bat[:any_2] ", "SQLntile;", "return the groups divided as
equally as possible" ]
[ "batsql", "ntile", "pattern batsql.ntile(b:bat[:any_1],
n:bat[:any_2], p:any_3, o:any_4):bat[:any_2] ", "SQLntile;", "return the
groups divided as equally as possible" ]
[ "batsql", "password", "pattern
batsql.password(user:bat[:str]):bat[:str] ", "db_password_wrap;", "Return
password hash of user" ]
@@ -9039,6 +9112,20 @@ stdout of test 'MAL-signatures` in direc
[ "batsql", "sum", "pattern batsql.sum(b:bat[:int], s:bat[:lng],
e:bat[:lng]):bat[:lng] ", "SQLsum;", "return the sum of groups" ]
[ "batsql", "sum", "pattern batsql.sum(b:bat[:lng], s:bat[:lng],
e:bat[:lng]):bat[:lng] ", "SQLsum;", "return the sum of groups" ]
[ "batsql", "sum", "pattern batsql.sum(b:bat[:sht], s:bat[:lng],
e:bat[:lng]):bat[:lng] ", "SQLsum;", "return the sum of groups" ]
+[ "batsql", "variance", "pattern batsql.variance(b:bat[:bte],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLvar_samp;", "return the variance
sample of groups" ]
+[ "batsql", "variance", "pattern batsql.variance(b:bat[:dbl],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLvar_samp;", "return the variance
sample of groups" ]
+[ "batsql", "variance", "pattern batsql.variance(b:bat[:flt],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLvar_samp;", "return the variance
sample of groups" ]
+[ "batsql", "variance", "pattern batsql.variance(b:bat[:hge],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLvar_samp;", "return the variance
of groups" ]
+[ "batsql", "variance", "pattern batsql.variance(b:bat[:int],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLvar_samp;", "return the variance
sample of groups" ]
+[ "batsql", "variance", "pattern batsql.variance(b:bat[:lng],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLvar_samp;", "return the variance
sample of groups" ]
+[ "batsql", "variance", "pattern batsql.variance(b:bat[:sht],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLvar_samp;", "return the variance
sample of groups" ]
+[ "batsql", "variancep", "pattern batsql.variancep(b:bat[:bte],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLvar_pop;", "return the variance
population of groups" ]
+[ "batsql", "variancep", "pattern batsql.variancep(b:bat[:dbl],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLvar_pop;", "return the variance
population of groups" ]
+[ "batsql", "variancep", "pattern batsql.variancep(b:bat[:flt],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLvar_pop;", "return the variance
population of groups" ]
+[ "batsql", "variancep", "pattern batsql.variancep(b:bat[:hge],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLvar_pop;", "return the variance
of groups" ]
+[ "batsql", "variancep", "pattern batsql.variancep(b:bat[:int],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLvar_pop;", "return the variance
population of groups" ]
+[ "batsql", "variancep", "pattern batsql.variancep(b:bat[:lng],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLvar_pop;", "return the variance
population of groups" ]
+[ "batsql", "variancep", "pattern batsql.variancep(b:bat[:sht],
s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLvar_pop;", "return the variance
population of groups" ]
[ "batsql", "window_bound", "pattern batsql.window_bound(b:bat[:any_1],
unit:int, bound:int, excl:int, limit:bat[:bte]):bat[:lng] ",
"SQLwindow_bound;", "computes window ranges for each row" ]
[ "batsql", "window_bound", "pattern batsql.window_bound(b:bat[:any_1],
unit:int, bound:int, excl:int, limit:bat[:dbl]):bat[:lng] ",
"SQLwindow_bound;", "computes window ranges for each row" ]
[ "batsql", "window_bound", "pattern batsql.window_bound(b:bat[:any_1],
unit:int, bound:int, excl:int, limit:bat[:flt]):bat[:lng] ",
"SQLwindow_bound;", "computes window ranges for each row" ]
@@ -11680,7 +11767,28 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "copy_from", "unsafe pattern sql.copy_from(t:ptr, sep:str,
rsep:str, ssep:str, ns:str, fname:str, nr:lng, offset:lng, locked:int,
best:int, fwf:str, onclient:int):bat[:any]... ", "mvc_import_table_wrap;",
"Import a table from bstream s with the \n\tgiven tuple and seperators
(sep/rsep)" ]
[ "sql", "copy_rejects", "pattern sql.copy_rejects() (rowid:bat[:lng],
fldid:bat[:int], msg:bat[:str], inp:bat[:str]) ", "COPYrejects;", "" ]
[ "sql", "copy_rejects_clear", "pattern sql.copy_rejects_clear():void
", "COPYrejects_clear;", "" ]
+[ "sql", "corr", "pattern sql.corr(b:bte, c:bte, s:lng, e:lng):dbl ",
"SQLcorr;", "return the correlation value of groups" ]
+[ "sql", "corr", "pattern sql.corr(b:dbl, c:dbl, s:lng, e:lng):dbl ",
"SQLcorr;", "return the correlation value of groups" ]
+[ "sql", "corr", "pattern sql.corr(b:flt, c:flt, s:lng, e:lng):dbl ",
"SQLcorr;", "return the correlation value of groups" ]
+[ "sql", "corr", "pattern sql.corr(b:hge, c:hge, s:lng, e:lng):dbl ",
"SQLcorr;", "return the correlation value of groups" ]
+[ "sql", "corr", "pattern sql.corr(b:int, c:int, s:lng, e:lng):dbl ",
"SQLcorr;", "return the correlation value of groups" ]
+[ "sql", "corr", "pattern sql.corr(b:lng, c:lng, s:lng, e:lng):dbl ",
"SQLcorr;", "return the correlation value of groups" ]
+[ "sql", "corr", "pattern sql.corr(b:sht, c:sht, s:lng, e:lng):dbl ",
"SQLcorr;", "return the correlation value of groups" ]
[ "sql", "count", "pattern sql.count(b:any_1, ignils:bit, s:lng,
e:lng):lng ", "SQLcount;", "return count of groups" ]
+[ "sql", "covariance", "pattern sql.covariance(b:bte, c:bte, s:lng,
e:lng):dbl ", "SQLcovar_samp;", "return the covariance sample value
of groups" ]
+[ "sql", "covariance", "pattern sql.covariance(b:dbl, c:dbl, s:lng,
e:lng):dbl ", "SQLcovar_samp;", "return the covariance sample value
of groups" ]
+[ "sql", "covariance", "pattern sql.covariance(b:flt, c:flt, s:lng,
e:lng):dbl ", "SQLcovar_samp;", "return the covariance sample value
of groups" ]
+[ "sql", "covariance", "pattern sql.covariance(b:hge, c:hge, s:lng,
e:lng):dbl ", "SQLcovar_samp;", "return the covariance sample value
of groups" ]
+[ "sql", "covariance", "pattern sql.covariance(b:int, c:int, s:lng,
e:lng):dbl ", "SQLcovar_samp;", "return the covariance sample value
of groups" ]
+[ "sql", "covariance", "pattern sql.covariance(b:lng, c:lng, s:lng,
e:lng):dbl ", "SQLcovar_samp;", "return the covariance sample value
of groups" ]
+[ "sql", "covariance", "pattern sql.covariance(b:sht, c:sht, s:lng,
e:lng):dbl ", "SQLcovar_samp;", "return the covariance sample value
of groups" ]
+[ "sql", "covariancep", "pattern sql.covariancep(b:bte, c:bte, s:lng,
e:lng):dbl ", "SQLcovar_pop;", "return the covariance population
value of groups" ]
+[ "sql", "covariancep", "pattern sql.covariancep(b:dbl, c:dbl, s:lng,
e:lng):dbl ", "SQLcovar_pop;", "return the covariance population
value of groups" ]
+[ "sql", "covariancep", "pattern sql.covariancep(b:flt, c:flt, s:lng,
e:lng):dbl ", "SQLcovar_pop;", "return the covariance population
value of groups" ]
+[ "sql", "covariancep", "pattern sql.covariancep(b:hge, c:hge, s:lng,
e:lng):dbl ", "SQLcovar_pop;", "return the covariance population
value of groups" ]
+[ "sql", "covariancep", "pattern sql.covariancep(b:int, c:int, s:lng,
e:lng):dbl ", "SQLcovar_pop;", "return the covariance population
value of groups" ]
+[ "sql", "covariancep", "pattern sql.covariancep(b:lng, c:lng, s:lng,
e:lng):dbl ", "SQLcovar_pop;", "return the covariance population
value of groups" ]
+[ "sql", "covariancep", "pattern sql.covariancep(b:sht, c:sht, s:lng,
e:lng):dbl ", "SQLcovar_pop;", "return the covariance population
value of groups" ]
[ "sql", "createorderindex", "pattern sql.createorderindex(sch:str,
tbl:str, col:str):void ", "sql_createorderindex;", "Instantiate
the order index on a column" ]
[ "sql", "cume_dist", "pattern sql.cume_dist(b:any_1, p:bit,
o:bit):dbl ", "SQLcume_dist;", "return the accumulated distribution
of the number of rows per group to the total number of partition rows" ]
[ "sql", "current_time", "pattern sql.current_time():daytime ",
"SQLcurrent_daytime;", "Get the clients current daytime" ]
@@ -11737,19 +11845,11 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "importTable", "unsafe pattern sql.importTable(sname:str,
tname:str, onclient:int, fname:str...):bat[:any]... ",
"mvc_bin_import_table_wrap;", "Import a table from the files (fname)" ]
[ "sql", "include", "pattern sql.include(fname:str):void ",
"SQLinclude;", "Compile and execute a sql statements on the file" ]
[ "sql", "lag", "pattern sql.lag(b:any_1, l:any_2, d:any_1, p:any_3,
o:any_4):any_1 ", "SQLlag;", "return the value in the previous 'l' row in
the partition or 'd' if non existent" ]
-[ "sql", "lag", "pattern sql.lag(b:any_1, l:any_2, d:bat[:any_1],
p:any_3, o:any_4):any_1 ", "SQLlag;", "return the value in the previous
'l' row in the partition or 'd' if non existent" ]
[ "sql", "lag", "pattern sql.lag(b:any_1, l:any_2, p:any_3,
o:any_4):any_1 ", "SQLlag;", "return the value in the previous 'l' row
in the partition or NULL if non existent" ]
-[ "sql", "lag", "pattern sql.lag(b:any_1, l:bat[:any_2], d:any_1,
p:any_3, o:any_4):any_1 ", "SQLlag;", "return the value in the previous
'l' row in the partition or 'd' if non existent" ]
-[ "sql", "lag", "pattern sql.lag(b:any_1, l:bat[:any_2], d:bat[:any_1],
p:any_3, o:any_4):any_1 ", "SQLlag;", "return the value in the
previous 'l' row in the partition or 'd' if non existent" ]
-[ "sql", "lag", "pattern sql.lag(b:any_1, l:bat[:any_2], p:any_3,
o:any_4):any_1 ", "SQLlag;", "return the value in the previous 'l' row
in the partition or NULL if non existent" ]
[ "sql", "lag", "pattern sql.lag(b:any_1, p:any_3, o:any_4):any_1 ",
"SQLlag;", "return the value in the previous row in the partition or NULL
if non existent" ]
[ "sql", "last_value", "pattern sql.last_value(b:any_1, s:lng,
e:lng):any_1 ", "SQLlast_value;", "return the last value of groups"
]
[ "sql", "lead", "pattern sql.lead(b:any_1, l:any_2, d:any_1, p:any_3,
o:any_4):any_1 ", "SQLlead;", "return the value in the next 'l' row in the
partition or 'd' if non existent" ]
-[ "sql", "lead", "pattern sql.lead(b:any_1, l:any_2, d:bat[:any_1],
p:any_3, o:any_4):any_1 ", "SQLlead;", "return the value in the next 'l'
row in the partition or 'd' if non existent" ]
[ "sql", "lead", "pattern sql.lead(b:any_1, l:any_2, p:any_3,
o:any_4):any_1 ", "SQLlead;", "return the value in the next 'l' row in the
partition or NULL if non existent" ]
-[ "sql", "lead", "pattern sql.lead(b:any_1, l:bat[:any_2], d:any_1,
p:any_3, o:any_4):any_1 ", "SQLlead;", "return the value in the next 'l'
row in the partition or 'd' if non existent" ]
-[ "sql", "lead", "pattern sql.lead(b:any_1, l:bat[:any_2],
d:bat[:any_1], p:any_3, o:any_4):any_1 ", "SQLlead;", "return the value
in the next 'l' row in the partition or 'd' if non existent" ]
-[ "sql", "lead", "pattern sql.lead(b:any_1, l:bat[:any_2], p:any_3,
o:any_4):any_1 ", "SQLlead;", "return the value in the next 'l' row in
the partition or NULL if non existent" ]
[ "sql", "lead", "pattern sql.lead(b:any_1, p:any_3, o:any_4):any_1 ",
"SQLlead;", "return the value in the next row in the partition or NULL if
non existent" ]
[ "sql", "logfile", "unsafe pattern sql.logfile(filename:str):void
", "mvc_logfile;", "Enable/disable saving the sql statement traces"
]
[ "sql", "max", "pattern sql.max(b:any_1, s:lng, e:lng):any_1 ",
"SQLmax;", "return the maximum of groups" ]
@@ -11760,9 +11860,7 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "next_value", "pattern sql.next_value(sname:str,
sequence:str):lng ", "mvc_next_value;", "return the next value of the
sequence" ]
[ "sql", "not_unique", "command sql.not_unique(b:bat[:oid]):bit ",
"not_unique;", "check if the tail sorted bat b doesn't have unique tail
values" ]
[ "sql", "nth_value", "pattern sql.nth_value(b:any_1, n:any_2, s:lng,
e:lng):any_1 ", "SQLnth_value;", "return the nth value of each group"
]
-[ "sql", "nth_value", "pattern sql.nth_value(b:any_1, n:bat[:any_2],
s:lng, e:lng):any_1 ", "SQLnth_value;", "return the nth value of each
group" ]
[ "sql", "ntile", "pattern sql.ntile(b:any_1, n:any_2, p:any_3,
o:any_4):any_2 ", "SQLntile;", "return the groups divided as equally as
possible" ]
-[ "sql", "ntile", "pattern sql.ntile(b:any_1, n:bat[:any_2],
p:any_3, o:any_4):any_2 ", "SQLntile;", "return the groups divided as
equally as possible" ]
[ "sql", "null", "command sql.null(b:bat[:any_1]):bit ", "SQLnil;",
"if b has a nil return true, else false" ]
[ "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;", "" ]
@@ -11815,10 +11913,26 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "single", "pattern sql.single(x:any_2):bat[:any_2] ",
"CMDBATsingle;", "" ]
[ "sql", "sql_environment", "inline function sql.sql_environment()
(name:bat[:str], value:bat[:str]);", "", "" ]
[ "sql", "sql_variables", "pattern sql.sql_variables():bat[:str]
", "sql_variables;", "return the table with session variables"
]
+[ "sql", "stdev", "pattern sql.stdev(b:bte, s:lng, e:lng):dbl ",
"SQLstddev_samp;", "return the standard deviation sample of groups"
]
+[ "sql", "stdev", "pattern sql.stdev(b:dbl, s:lng, e:lng):dbl ",
"SQLstddev_samp;", "return the standard deviation sample of groups"
]
+[ "sql", "stdev", "pattern sql.stdev(b:flt, s:lng, e:lng):dbl ",
"SQLstddev_samp;", "return the standard deviation sample of groups"
]
+[ "sql", "stdev", "pattern sql.stdev(b:hge, s:lng, e:lng):dbl ",
"SQLstddev_samp;", "return the standard deviation of groups" ]
+[ "sql", "stdev", "pattern sql.stdev(b:int, s:lng, e:lng):dbl ",
"SQLstddev_samp;", "return the standard deviation sample of groups"
]
+[ "sql", "stdev", "pattern sql.stdev(b:lng, s:lng, e:lng):dbl ",
"SQLstddev_samp;", "return the standard deviation sample of groups"
]
+[ "sql", "stdev", "pattern sql.stdev(b:sht, s:lng, e:lng):dbl ",
"SQLstddev_samp;", "return the standard deviation sample of groups"
]
+[ "sql", "stdevp", "pattern sql.stdevp(b:bte, s:lng, e:lng):dbl ",
"SQLstddev_pop;", "return the standard deviation population of groups"
]
+[ "sql", "stdevp", "pattern sql.stdevp(b:dbl, s:lng, e:lng):dbl ",
"SQLstddev_pop;", "return the standard deviation population of groups"
]
+[ "sql", "stdevp", "pattern sql.stdevp(b:flt, s:lng, e:lng):dbl ",
"SQLstddev_pop;", "return the standard deviation population of groups"
]
+[ "sql", "stdevp", "pattern sql.stdevp(b:hge, s:lng, e:lng):dbl ",
"SQLstddev_pop;", "return the standard deviation of groups" ]
+[ "sql", "stdevp", "pattern sql.stdevp(b:int, s:lng, e:lng):dbl ",
"SQLstddev_pop;", "return the standard deviation population of groups"
]
+[ "sql", "stdevp", "pattern sql.stdevp(b:lng, s:lng, e:lng):dbl ",
"SQLstddev_pop;", "return the standard deviation population of groups"
]
+[ "sql", "stdevp", "pattern sql.stdevp(b:sht, s:lng, e:lng):dbl ",
"SQLstddev_pop;", "return the standard deviation population of groups"
]
[ "sql", "storage", "pattern sql.storage() (schema:bat[:str],
table:bat[:str], column:bat[:str], type:bat[:str], mode:bat[:str],
location:bat[:str], count:bat[:lng], atomwidth:bat[:int], columnsize:bat[:lng],
heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit], imprints:bat[:lng],
sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit], orderidx:bat[:lng]) ",
"sql_storage;", "return a table with storage information " ]
[ "sql", "storage", "pattern sql.storage(sname:str)
(schema:bat[:str], table:bat[:str], column:bat[:str], type:bat[:str],
mode:bat[:str], location:bat[:str], count:bat[:lng], atomwidth:bat[:int],
columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit],
imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit],
orderidx:bat[:lng]) ", "sql_storage;", "return a table with storage
information for a particular schema " ]
[ "sql", "storage", "pattern sql.storage(sname:str, tname:str)
(schema:bat[:str], table:bat[:str], column:bat[:str], type:bat[:str],
mode:bat[:str], location:bat[:str], count:bat[:lng], atomwidth:bat[:int],
columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit],
imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit],
orderidx:bat[:lng]) ", "sql_storage;", "return a table with storage
information for a particular table" ]
[ "sql", "storage", "pattern sql.storage(sname:str, tname:str,
cname:str) (schema:bat[:str], table:bat[:str], column:bat[:str],
type:bat[:str], mode:bat[:str], location:bat[:str], count:bat[:lng],
atomwidth:bat[:int], columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng],
phash:bat[:bit], imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit],
key:bat[:bit], orderidx:bat[:lng]) ", "sql_storage;", "return a table with
storage information for a particular column" ]
+[ "sql", "str_group_concat", "pattern sql.str_group_concat(b:str,
s:lng, e:lng):str ", "SQLstrgroup_concat;", "return the string
concatenation of groups" ]
+[ "sql", "str_group_concat", "pattern sql.str_group_concat(b:str,
sep:str, s:lng, e:lng):str ", "SQLstrgroup_concat;", "return the string
concatenation of groups with a custom separator" ]
[ "sql", "suball", "command sql.suball(l:bat[:any_1],
gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:any_1] ", "SQLall_grp;",
"if all values in l are equal (per group) return the value, else nil" ]
[ "sql", "subdelta", "command sql.subdelta(col:bat[:oid],
cand:bat[:oid], uid:bat[:oid], uval:bat[:oid]):bat[:oid] ",
"DELTAsub2;", "Return a single bat of selected delta." ]
[ "sql", "subdelta", "command sql.subdelta(col:bat[:oid],
cand:bat[:oid], uid:bat[:oid], uval:bat[:oid], ins:bat[:oid]):bat[:oid] ",
"DELTAsub;", "Return a single bat of selected delta." ]
@@ -11857,6 +11971,20 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "update_schemas", "pattern sql.update_schemas():void ",
"SYSupdate_schemas;", "Procedure triggered on update of the sys.schemas
table" ]
[ "sql", "update_tables", "pattern sql.update_tables():void ",
"SYSupdate_tables;", "Procedure triggered on update of the sys._tables
table" ]
[ "sql", "vacuum", "pattern sql.vacuum(sch:str, tbl:str):void ",
"SQLvacuum;", "Choose an approach to consolidate the deletions" ]
+[ "sql", "variance", "pattern sql.variance(b:bte, s:lng, e:lng):dbl
", "SQLvar_samp;", "return the variance sample of groups" ]
+[ "sql", "variance", "pattern sql.variance(b:dbl, s:lng, e:lng):dbl
", "SQLvar_samp;", "return the variance sample of groups" ]
+[ "sql", "variance", "pattern sql.variance(b:flt, s:lng, e:lng):dbl
", "SQLvar_samp;", "return the variance sample of groups" ]
+[ "sql", "variance", "pattern sql.variance(b:hge, s:lng, e:lng):dbl
", "SQLvar_samp;", "return the variance of groups" ]
+[ "sql", "variance", "pattern sql.variance(b:int, s:lng, e:lng):dbl
", "SQLvar_samp;", "return the variance sample of groups" ]
+[ "sql", "variance", "pattern sql.variance(b:lng, s:lng, e:lng):dbl
", "SQLvar_samp;", "return the variance sample of groups" ]
+[ "sql", "variance", "pattern sql.variance(b:sht, s:lng, e:lng):dbl
", "SQLvar_samp;", "return the variance sample of groups" ]
+[ "sql", "variancep", "pattern sql.variancep(b:bte, s:lng, e:lng):dbl
", "SQLvar_pop;", "return the variance population of groups" ]
+[ "sql", "variancep", "pattern sql.variancep(b:dbl, s:lng, e:lng):dbl
", "SQLvar_pop;", "return the variance population of groups" ]
+[ "sql", "variancep", "pattern sql.variancep(b:flt, s:lng, e:lng):dbl
", "SQLvar_pop;", "return the variance population of groups" ]
+[ "sql", "variancep", "pattern sql.variancep(b:hge, s:lng, e:lng):dbl
", "SQLvar_pop;", "return the variance of groups" ]
+[ "sql", "variancep", "pattern sql.variancep(b:int, s:lng, e:lng):dbl
", "SQLvar_pop;", "return the variance population of groups" ]
+[ "sql", "variancep", "pattern sql.variancep(b:lng, s:lng, e:lng):dbl
", "SQLvar_pop;", "return the variance population of groups" ]
+[ "sql", "variancep", "pattern sql.variancep(b:sht, s:lng, e:lng):dbl
", "SQLvar_pop;", "return the variance population of groups" ]
[ "sql", "window_bound", "pattern sql.window_bound(b:any_1, unit:int,
bound:int, excl:int, limit:bte):lng ", "SQLwindow_bound;", "computes
window ranges for each row" ]
[ "sql", "window_bound", "pattern sql.window_bound(b:any_1, unit:int,
bound:int, excl:int, limit:dbl):lng ", "SQLwindow_bound;", "computes
window ranges for each row" ]
[ "sql", "window_bound", "pattern sql.window_bound(b:any_1, unit:int,
bound:int, excl:int, limit:flt):lng ", "SQLwindow_bound;", "computes
window ranges for each row" ]
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
@@ -101,13 +101,14 @@ stdout of test 'MAL-signatures` in direc
[ "aggr", "avg", "pattern aggr.avg(b:bat[:any_2]):dbl ", "CMDcalcavg;",
"Gives the avg of all tail values" ]
[ "aggr", "avg", "pattern aggr.avg(b:bat[:any_2], scale:int):dbl ",
"CMDcalcavg;", "Gives the avg of all tail values" ]
[ "aggr", "cardinality", "command aggr.cardinality(b:bat[:any_2]):lng ",
"ALGcard;", "Return the cardinality of the BAT tail values." ]
-[ "aggr", "corr", "function aggr.corr(e1:bat[:bte], e2:bat[:bte]):dbl;",
"", "" ]
-[ "aggr", "corr", "function aggr.corr(e1:bat[:dbl], e2:bat[:dbl]):dbl;",
"", "" ]
-[ "aggr", "corr", "function aggr.corr(e1:bat[:flt], e2:bat[:flt]):dbl;",
"", "" ]
-[ "aggr", "corr", "function aggr.corr(e1:bat[:hge], e2:bat[:hge]):dbl;",
"", "" ]
-[ "aggr", "corr", "function aggr.corr(e1:bat[:int], e2:bat[:int]):dbl;",
"", "" ]
-[ "aggr", "corr", "function aggr.corr(e1:bat[:lng], e2:bat[:lng]):dbl;",
"", "" ]
-[ "aggr", "corr", "function aggr.corr(e1:bat[:sht], e2:bat[:sht]):dbl;",
"", "" ]
+[ "aggr", "corr", "command aggr.corr(b1:bat[:bte], b2:bat[:bte],
g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation
aggregate" ]
+[ "aggr", "corr", "command aggr.corr(b1:bat[:dbl], b2:bat[:dbl],
g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation
aggregate" ]
+[ "aggr", "corr", "command aggr.corr(b1:bat[:flt], b2:bat[:flt],
g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation
aggregate" ]
+[ "aggr", "corr", "command aggr.corr(b1:bat[:hge], b2:bat[:hge],
g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation
aggregate" ]
+[ "aggr", "corr", "command aggr.corr(b1:bat[:int], b2:bat[:int],
g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation
aggregate" ]
+[ "aggr", "corr", "command aggr.corr(b1:bat[:lng], b2:bat[:lng],
g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation
aggregate" ]
+[ "aggr", "corr", "command aggr.corr(b1:bat[:sht], b2:bat[:sht],
g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation
aggregate" ]
+[ "aggr", "corr", "command aggr.corr(b1:bat[:any_2], b2:bat[:any_2]):dbl
", "ALGcorr;", "Gives the correlation of all tail values" ]
[ "aggr", "count", "command aggr.count(b:bat[:any_1], g:bat[:oid],
e:bat[:any_2], ignorenils:bit):bat[:lng] ", "AGGRcount3;", "" ]
[ "aggr", "count", "command aggr.count(b:bat[:any_1], g:bat[:oid],
e:bat[:any_2]):bat[:lng] ", "AGGRcount3nils;", "Grouped count" ]
[ "aggr", "count", "command aggr.count(b:bat[:any],
cnd:bat[:oid]):lng ", "ALGcountCND_bat;", "Return the current size (in
number of elements) in a BAT." ]
@@ -117,13 +118,22 @@ stdout of test 'MAL-signatures` in direc
[ "aggr", "count_no_nil", "command aggr.count_no_nil(b:bat[:any_1],
g:bat[:oid], e:bat[:any_2]):bat[:lng] ", "AGGRcount3nonils;", "" ]
[ "aggr", "count_no_nil", "command aggr.count_no_nil(b:bat[:any_2],
cnd:bat[:oid]):lng ", "ALGcountCND_no_nil;", "Return the number of elements
currently\n\tin a BAT ignoring BUNs with nil-tail" ]
[ "aggr", "count_no_nil", "command aggr.count_no_nil(b:bat[:any_2]):lng
", "ALGcount_no_nil;", "Return the number of elements
currently\n\tin a BAT ignoring BUNs with nil-tail" ]
-[ "aggr", "covar", "function aggr.covar(e1:bat[:bte],
e2:bat[:bte]):dbl;", "", "" ]
-[ "aggr", "covar", "function aggr.covar(e1:bat[:dbl],
e2:bat[:dbl]):dbl;", "", "" ]
-[ "aggr", "covar", "function aggr.covar(e1:bat[:flt],
e2:bat[:flt]):dbl;", "", "" ]
-[ "aggr", "covar", "function aggr.covar(e1:bat[:hge],
e2:bat[:hge]):dbl;", "", "" ]
-[ "aggr", "covar", "function aggr.covar(e1:bat[:int],
e2:bat[:int]):dbl;", "", "" ]
-[ "aggr", "covar", "function aggr.covar(e1:bat[:lng],
e2:bat[:lng]):dbl;", "", "" ]
-[ "aggr", "covar", "function aggr.covar(e1:bat[:sht],
e2:bat[:sht]):dbl;", "", "" ]
+[ "aggr", "covariance", "command aggr.covariance(b1:bat[:bte],
b2:bat[:bte], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;",
"Covariance sample aggregate" ]
+[ "aggr", "covariance", "command aggr.covariance(b1:bat[:dbl],
b2:bat[:dbl], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;",
"Covariance sample aggregate" ]
+[ "aggr", "covariance", "command aggr.covariance(b1:bat[:flt],
b2:bat[:flt], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;",
"Covariance sample aggregate" ]
+[ "aggr", "covariance", "command aggr.covariance(b1:bat[:hge],
b2:bat[:hge], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;",
"Covariance sample aggregate" ]
+[ "aggr", "covariance", "command aggr.covariance(b1:bat[:int],
b2:bat[:int], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;",
"Covariance sample aggregate" ]
+[ "aggr", "covariance", "command aggr.covariance(b1:bat[:lng],
b2:bat[:lng], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;",
"Covariance sample aggregate" ]
+[ "aggr", "covariance", "command aggr.covariance(b1:bat[:sht],
b2:bat[:sht], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;",
"Covariance sample aggregate" ]
+[ "aggr", "covariance", "command aggr.covariance(b1:bat[:any_2],
b2:bat[:any_2]):dbl ", "ALGcovariance;", "Gives the covariance of all
tail values" ]
+[ "aggr", "covariancep", "command aggr.covariancep(b1:bat[:bte],
b2:bat[:bte], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;",
"Covariance population aggregate" ]
+[ "aggr", "covariancep", "command aggr.covariancep(b1:bat[:dbl],
b2:bat[:dbl], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;",
"Covariance population aggregate" ]
+[ "aggr", "covariancep", "command aggr.covariancep(b1:bat[:flt],
b2:bat[:flt], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;",
"Covariance population aggregate" ]
+[ "aggr", "covariancep", "command aggr.covariancep(b1:bat[:hge],
b2:bat[:hge], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;",
"Covariance population aggregate" ]
+[ "aggr", "covariancep", "command aggr.covariancep(b1:bat[:int],
b2:bat[:int], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;",
"Covariance population aggregate" ]
+[ "aggr", "covariancep", "command aggr.covariancep(b1:bat[:lng],
b2:bat[:lng], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;",
"Covariance population aggregate" ]
+[ "aggr", "covariancep", "command aggr.covariancep(b1:bat[:sht],
b2:bat[:sht], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;",
"Covariance population aggregate" ]
+[ "aggr", "covariancep", "command aggr.covariancep(b1:bat[:any_2],
b2:bat[:any_2]):dbl ", "ALGcovariancep;", "Gives the covariance of
all tail values" ]
[ "aggr", "exist", "command aggr.exist(b:bat[:any_2], h:any_1):bit
", "ALGexist;", "" ]
[ "aggr", "exist", "command aggr.exist(b:bat[:any_2]):bit ",
"SQLexist;", "" ]
[ "aggr", "exist", "pattern aggr.exist(v:any_2):bit ",
"SQLexist_val;", "" ]
@@ -334,22 +344,50 @@ stdout of test 'MAL-signatures` in direc
[ "aggr", "subavg", "command aggr.subavg(b:bat[:int], g:bat[:oid],
e:bat[:any_1], s:bat[:oid], skip_nils:bit, abort_on_error:bit, scale:int)
(X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRsubavg2scand_dbl;", "Grouped
average aggregate with candidates list, also returns count" ]
[ "aggr", "subavg", "command aggr.subavg(b:bat[:lng], g:bat[:oid],
e:bat[:any_1], s:bat[:oid], skip_nils:bit, abort_on_error:bit, scale:int)
(X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRsubavg2scand_dbl;", "Grouped
average aggregate with candidates list, also returns count" ]
[ "aggr", "subavg", "command aggr.subavg(b:bat[:sht], g:bat[:oid],
e:bat[:any_1], s:bat[:oid], skip_nils:bit, abort_on_error:bit, scale:int)
(X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRsubavg2scand_dbl;", "Grouped
average aggregate with candidates list, also returns count" ]
-[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:bte],
e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", ""
]
-[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:dbl],
e2:bat[:dbl], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", ""
]
-[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:flt],
e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", ""
]
-[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:hge],
e2:bat[:hge], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", ""
]
-[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:int],
e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", ""
]
-[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:lng],
e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", ""
]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
