Changeset: 4f5f8edc9e1b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4f5f8edc9e1b Modified Files: clients/Tests/MAL-signatures.test clients/Tests/exports.stable.out sql/test/emptydb/Tests/check.stable.out Branch: default Log Message:
Approve non-hge output. diffs (131 lines): diff --git a/clients/Tests/MAL-signatures.test b/clients/Tests/MAL-signatures.test --- a/clients/Tests/MAL-signatures.test +++ b/clients/Tests/MAL-signatures.test @@ -864,6 +864,36 @@ command aggr.quantile_avg(X_0:bat[:any_1 AGGRquantile_avg_cst Quantile aggregate aggr +ripemd160 +command aggr.ripemd160(X_0:bat[:str]):str +AGGRripemd160 +Ungrouped RIPEMD160 +aggr +sha1 +command aggr.sha1(X_0:bat[:str]):str +AGGRsha1 +Ungrouped SHA1 +aggr +sha224 +command aggr.sha224(X_0:bat[:str]):str +AGGRsha224 +Ungrouped SHA224 +aggr +sha256 +command aggr.sha256(X_0:bat[:str]):str +AGGRsha256 +Ungrouped SHA256 +aggr +sha384 +command aggr.sha384(X_0:bat[:str]):str +AGGRsha384 +Ungrouped SHA384 +aggr +sha512 +command aggr.sha512(X_0:bat[:str]):str +AGGRsha512 +Ungrouped SHA512 +aggr stdev command aggr.stdev(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] AGGRstdev3_dbl @@ -1734,6 +1764,36 @@ command aggr.subquantile_avg(X_0:bat[:an AGGRsubquantilecand_avg Grouped quantile aggregate with candidate list aggr +subripemd160 +command aggr.subripemd160(X_0:bat[:str], X_1:bat[:oid], X_2:bat[:any_1], X_3:bit):bat[:str] +AGGRripemd160grouped +Grouped RIPEMD160 +aggr +subsha1 +command aggr.subsha1(X_0:bat[:str], X_1:bat[:oid], X_2:bat[:any_1], X_3:bit):bat[:str] +AGGRsha1grouped +Grouped SHA1 +aggr +subsha224 +command aggr.subsha224(X_0:bat[:str], X_1:bat[:oid], X_2:bat[:any_1], X_3:bit):bat[:str] +AGGRsha224grouped +Grouped SHA224 +aggr +subsha256 +command aggr.subsha256(X_0:bat[:str], X_1:bat[:oid], X_2:bat[:any_1], X_3:bit):bat[:str] +AGGRsha256grouped +Grouped SHA256 +aggr +subsha384 +command aggr.subsha384(X_0:bat[:str], X_1:bat[:oid], X_2:bat[:any_1], X_3:bit):bat[:str] +AGGRsha384grouped +Grouped SHA384 +aggr +subsha512 +command aggr.subsha512(X_0:bat[:str], X_1:bat[:oid], X_2:bat[:any_1], X_3:bit):bat[:str] +AGGRsha512grouped +Grouped SHA512 +aggr substdev command aggr.substdev(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1], X_3:bit):bat[:dbl] AGGRsubstdev_dbl diff --git a/clients/Tests/exports.stable.out b/clients/Tests/exports.stable.out --- a/clients/Tests/exports.stable.out +++ b/clients/Tests/exports.stable.out @@ -10,6 +10,7 @@ size_t ATOMlen(int id, const void *v); const char *ATOMname(int id); void *ATOMnil(int id) __attribute__((__malloc__)); int ATOMprint(allocator *ma, int id, const void *val, stream *fd); +gdk_return BATaggrdigest(allocator *ma, BAT **bnp, char **shap, const char *digest, BAT *b, BAT *g, BAT *e, BAT *s, bool skip_nils); BAT *BATall_grp(BAT *l, BAT *g, BAT *e, BAT *s); BAT *BATallnotequal_grp(BAT *l, BAT *r, BAT *g, BAT *e, BAT *s); BAT *BATallnotequal_grp2(BAT *l, BAT *r, BAT *rid, BAT *g, BAT *e, BAT *s); diff --git a/sql/test/emptydb/Tests/check.stable.out b/sql/test/emptydb/Tests/check.stable.out --- a/sql/test/emptydb/Tests/check.stable.out +++ b/sql/test/emptydb/Tests/check.stable.out @@ -2297,6 +2297,7 @@ select 'null in fkeys.delete_action', de [ "sys.functions", "sys", "right_shift", "SYSTEM", "mbrRight", "geom", "Internal C", "Scalar function", false, false, false, true, NULL, "res_0", "boolean", 1, 0, "out", "arg_1", "geometry", 0, 0, "in", "arg_2", "geometry", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "right_shift", "SYSTEM", "mbrRight", "geom", "Internal C", "Scalar function", false, false, false, true, NULL, "res_0", "boolean", 1, 0, "out", "arg_1", "mbr", 0, 0, "in", "arg_2", "mbr", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "right_shift_assign", "SYSTEM", "create function \"right_shift_assign\"(i1 inet, i2 inet) returns boolean external name inet.\">>=\";", "inet", "MAL", "Scalar function", false, false, false, true, NULL, "result", "boolean", 1, 0, "out", "i1", "inet", 0, 0, "in", "i2", "inet", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "ripemd160", "SYSTEM", "create aggregate ripemd160(val string) returns string with order external name aggr.ripemd160;", "aggr", "MAL", "Aggregate function", false, false, false, true, NULL, "result", "varchar", 0, 0, "out", "val", "varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "round", "SYSTEM", "round", "calc", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "decimal", 2, 0, "out", "arg_1", "decimal", 2, 0, "in", "arg_2", "tinyint", 7, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "round", "SYSTEM", "round", "calc", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "decimal", 4, 0, "out", "arg_1", "decimal", 4, 0, "in", "arg_2", "tinyint", 7, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "round", "SYSTEM", "round", "calc", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "decimal", 9, 0, "out", "arg_1", "decimal", 9, 0, "in", "arg_2", "tinyint", 7, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] @@ -2327,6 +2328,11 @@ select 'null in fkeys.delete_action', de [ "sys.functions", "sys", "setsessiontimeout", "SYSTEM", "create procedure sys.setsessiontimeout(\"timeout\" int) external name clients.setsessiontimeout;", "clients", "MAL", "Procedure", true, false, false, true, NULL, "timeout", "int", 31, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "setworkerlimit", "SYSTEM", "create procedure sys.setworkerlimit(\"limit\" int) external name clients.setworkerlimit;", "clients", "MAL", "Procedure", true, false, false, true, NULL, "limit", "int", 31, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "setworkerlimit", "SYSTEM", "create procedure sys.setworkerlimit(\"sessionid\" int, \"limit\" int) external name clients.setworkerlimit;", "clients", "MAL", "Procedure", true, false, false, true, NULL, "sessionid", "int", 31, 0, "in", "limit", "int", 31, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "sha1", "SYSTEM", "create aggregate sha1(val string) returns string with order external name aggr.sha1;", "aggr", "MAL", "Aggregate function", false, false, false, true, NULL, "result", "varchar", 0, 0, "out", "val", "varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "sha224", "SYSTEM", "create aggregate sha224(val string) returns string with order external name aggr.sha224;", "aggr", "MAL", "Aggregate function", false, false, false, true, NULL, "result", "varchar", 0, 0, "out", "val", "varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "sha256", "SYSTEM", "create aggregate sha256(val string) returns string with order external name aggr.sha256;", "aggr", "MAL", "Aggregate function", false, false, false, true, NULL, "result", "varchar", 0, 0, "out", "val", "varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "sha384", "SYSTEM", "create aggregate sha384(val string) returns string with order external name aggr.sha384;", "aggr", "MAL", "Aggregate function", false, false, false, true, NULL, "result", "varchar", 0, 0, "out", "val", "varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "sha512", "SYSTEM", "create aggregate sha512(val string) returns string with order external name aggr.sha512;", "aggr", "MAL", "Aggregate function", false, false, false, true, NULL, "result", "varchar", 0, 0, "out", "val", "varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "shpload", "SYSTEM", "create procedure shpload(fname string, schemaname string, tablename string) external name shp.load;", "shp", "MAL", "Procedure", false, false, false, true, NULL, "fname", "varchar", 0, 0, "in", "schemaname", "varchar", 0, 0, "in", "tablename", "varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "shpload", "SYSTEM", "create procedure shpload(fname string, tablename string) external name shp.load;", "shp", "MAL", "Procedure", false, false, false, true, NULL, "fname", "varchar", 0, 0, "in", "tablename", "varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "shutdown", "SYSTEM", "create procedure sys.shutdown(delay tinyint) external name sql.shutdown;", "sql", "MAL", "Procedure", true, false, false, true, NULL, "delay", "tinyint", 7, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] @@ -4941,6 +4947,7 @@ select 'null in fkeys.delete_action', de [ "grant on function", "sys", "resume", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "right_shift", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "right_shift_assign", "public", "EXECUTE", "monetdb", 0 ] +[ "grant on function", "sys", "ripemd160", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "setclientinfo", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "setmasklen", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "setmemorylimit", "public", "EXECUTE", "monetdb", 0 ] @@ -4948,6 +4955,11 @@ select 'null in fkeys.delete_action', de [ "grant on function", "sys", "setquerytimeout", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "setsessiontimeout", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "setworkerlimit", "public", "EXECUTE", "monetdb", 0 ] +[ "grant on function", "sys", "sha1", "public", "EXECUTE", "monetdb", 0 ] +[ "grant on function", "sys", "sha224", "public", "EXECUTE", "monetdb", 0 ] +[ "grant on function", "sys", "sha256", "public", "EXECUTE", "monetdb", 0 ] +[ "grant on function", "sys", "sha384", "public", "EXECUTE", "monetdb", 0 ] +[ "grant on function", "sys", "sha512", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "soundex", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "sql_datatype", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "st_area", "public", "EXECUTE", "monetdb", 0 ] _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
