Changeset: f445d2949471 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f445d2949471
Modified Files:
sql/common/sql_types.c
sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.sql
sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.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: Nov2019
Log Message:
Several changes:
-Removed 'avg' window function aggregate with sec_interval as input, derived
from the respective aggregate being removed.
-Added SYS.STR_TO_TIMESTAMP('0', '%s') call back in bug 6783 test, because it's
failing on Windows.
-Approved tests from recent changes.
diffs (133 lines):
diff --git a/sql/common/sql_types.c b/sql/common/sql_types.c
--- a/sql/common/sql_types.c
+++ b/sql/common/sql_types.c
@@ -1858,7 +1858,7 @@ sqltypeinit( sql_allocator *sa)
#endif
sql_create_analytic(sa, "avg", "sql", "avg", MONINT, DBL, SCALE_NONE);
- sql_create_analytic(sa, "avg", "sql", "avg", SECINT, DBL, SCALE_NONE);
+ //sql_create_analytic(sa, "avg", "sql", "avg", SECINT, DBL, SCALE_NONE);
#if 0
t = decimals; // BTE
diff --git
a/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.sql
b/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.sql
--- a/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.sql
+++ b/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.sql
@@ -3,4 +3,6 @@ CREATE TABLE bug6783 (t TIMESTAMP);
INSERT INTO bug6783 values (SYS.STR_TO_TIMESTAMP('1970-01-01 00:02:55',
'%Y-%m-%d %T'));
SELECT t - SYS.STR_TO_TIMESTAMP('1970-01-01 00:00:00', '%Y-%m-%d %T') FROM
bug6783;
SELECT AVG(t - SYS.STR_TO_TIMESTAMP('1970-01-01 00:00:00', '%Y-%m-%d %T'))
FROM bug6783;
+
+INSERT INTO bug6783 values (SYS.STR_TO_TIMESTAMP('0', '%s'));
ROLLBACK;
diff --git
a/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.stable.out
b/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.stable.out
--- a/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.stable.out
+++ b/sql/test/BugTracker-2019/Tests/avg-changes-value-scale.Bug-6783.stable.out
@@ -70,6 +70,8 @@ stdout of test 'avg-changes-value-scale.
% double # type
% 24 # length
[ 175 ]
+#INSERT INTO bug6783 values (SYS.STR_TO_TIMESTAMP('0', '%s'));
+[ 1 ]
#ROLLBACK;
# 16:29:22 >
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
@@ -2206,7 +2206,6 @@ drop function pcre_replace(string, strin
[ "sys", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "int", 32, 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", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "month_interval", 32, 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", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "real", 24, 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", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "sec_interval", 13, 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", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "smallint", 16, 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", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "tinyint", 8, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "bigint", 64, 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
]
@@ -2214,7 +2213,6 @@ drop function pcre_replace(string, strin
[ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "int", 32, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "month_interval", 32, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "real", 24, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "sec_interval", 13, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "smallint", 16, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "tinyint", 8, 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", "bbp", "SYSTEM", "create function sys.bbp () returns
table (id int, name string, ttype string, count bigint, refcnt int, lrefcnt
int, location string, heat int, dirty string, status string, kind string)
external name bbp.get;", "bbp", "MAL", "Function returning a table",
true, false, false, "id", "int", 32, 0, "out", "name", "clob",
0, 0, "out", "ttype", "clob", 0, 0, "out",
"count", "bigint", 64, 0, "out", "refcnt", "int",
32, 0, "out", "lrefcnt", "int", 32, 0, "out",
"location", "clob", 0, 0, "out", "heat", "int", 32, 0,
"out", "dirty", "clob", 0, 0, "out", "status", "clob",
0, 0, "out", "kind", "clob", 0, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit
b/sql/test/emptydb/Tests/check.stable.out.32bit
--- a/sql/test/emptydb/Tests/check.stable.out.32bit
+++ b/sql/test/emptydb/Tests/check.stable.out.32bit
@@ -2206,7 +2206,6 @@ drop function pcre_replace(string, strin
[ "sys", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "int", 32, 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", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "month_interval", 32, 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", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "real", 24, 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", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "sec_interval", 13, 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", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "smallint", 16, 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", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "tinyint", 8, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "bigint", 64, 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
]
@@ -2214,7 +2213,6 @@ drop function pcre_replace(string, strin
[ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "int", 32, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "month_interval", 32, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "real", 24, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "sec_interval", 13, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "smallint", 16, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "tinyint", 8, 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", "bbp", "SYSTEM", "create function sys.bbp () returns
table (id int, name string, ttype string, count bigint, refcnt int, lrefcnt
int, location string, heat int, dirty string, status string, kind string)
external name bbp.get;", "bbp", "MAL", "Function returning a table",
true, false, false, "id", "int", 32, 0, "out", "name", "clob",
0, 0, "out", "ttype", "clob", 0, 0, "out",
"count", "bigint", 64, 0, "out", "refcnt", "int",
32, 0, "out", "lrefcnt", "int", 32, 0, "out",
"location", "clob", 0, 0, "out", "heat", "int", 32, 0,
"out", "dirty", "clob", 0, 0, "out", "status", "clob",
0, 0, "out", "kind", "clob", 0, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
diff --git a/sql/test/emptydb/Tests/check.stable.out.int128
b/sql/test/emptydb/Tests/check.stable.out.int128
--- a/sql/test/emptydb/Tests/check.stable.out.int128
+++ b/sql/test/emptydb/Tests/check.stable.out.int128
@@ -2222,7 +2222,6 @@ drop function pcre_replace(string, strin
[ "sys", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "int", 32, 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", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "month_interval", 32, 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", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "real", 24, 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", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "sec_interval", 13, 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", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "smallint", 16, 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", "avg", "SYSTEM", "avg", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "double", 53,
0, "out", "arg", "tinyint", 8, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "bigint", 64, 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
]
@@ -2231,7 +2230,6 @@ drop function pcre_replace(string, strin
[ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "int", 32, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "month_interval", 32, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "real", 24, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "sec_interval", 13, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "smallint", 16, 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", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "tinyint", 8, 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", "bbp", "SYSTEM", "create function sys.bbp () returns
table (id int, name string, ttype string, count bigint, refcnt int, lrefcnt
int, location string, heat int, dirty string, status string, kind string)
external name bbp.get;", "bbp", "MAL", "Function returning a table",
true, false, false, "id", "int", 32, 0, "out", "name", "clob",
0, 0, "out", "ttype", "clob", 0, 0, "out",
"count", "bigint", 64, 0, "out", "refcnt", "int",
32, 0, "out", "lrefcnt", "int", 32, 0, "out",
"location", "clob", 0, 0, "out", "heat", "int", 32, 0,
"out", "dirty", "clob", 0, 0, "out", "status", "clob",
0, 0, "out", "kind", "clob", 0, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
diff --git a/sql/test/sys-schema/Tests/systemfunctions.stable.out
b/sql/test/sys-schema/Tests/systemfunctions.stable.out
--- a/sql/test/sys-schema/Tests/systemfunctions.stable.out
+++ b/sql/test/sys-schema/Tests/systemfunctions.stable.out
@@ -220,8 +220,6 @@ stdout of test 'systemfunctions` in dire
[ "sys", "avg", 0, "double", "avg" ]
[ "sys", "avg", 1, "month_interval", "" ]
[ "sys", "avg", 0, "double", "avg" ]
-[ "sys", "avg", 1, "sec_interval", "" ]
-[ "sys", "avg", 0, "double", "avg" ]
[ "sys", "avg", 1, "double", "" ]
[ "sys", "avg", 0, "double", "avg" ]
[ "sys", "avg", 1, "tinyint", "" ]
@@ -234,8 +232,6 @@ stdout of test 'systemfunctions` in dire
[ "sys", "avg", 0, "double", "avg" ]
[ "sys", "avg", 1, "month_interval", "" ]
[ "sys", "avg", 0, "double", "avg" ]
-[ "sys", "avg", 1, "sec_interval", "" ]
-[ "sys", "avg", 0, "double", "avg" ]
[ "sys", "avg", 1, "real", "" ]
[ "sys", "bbp", 0, "int", "create function sys.bbp ()\n returns
table (id int, name string,\n ttype string, count bigint, refcnt int, lrefcnt
int,\n location string, heat int, dirty string,\n status string, kind string)\n
external name bbp.get;" ]
[ "sys", "bbp", 1, "clob", "" ]
diff --git a/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
b/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
--- a/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
+++ b/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
@@ -229,8 +229,6 @@ stdout of test 'systemfunctions` in dire
[ "sys", "avg", 0, "double", "avg" ]
[ "sys", "avg", 1, "month_interval", "" ]
[ "sys", "avg", 0, "double", "avg" ]
-[ "sys", "avg", 1, "sec_interval", "" ]
-[ "sys", "avg", 0, "double", "avg" ]
[ "sys", "avg", 1, "double", "" ]
[ "sys", "avg", 0, "double", "avg" ]
[ "sys", "avg", 1, "tinyint", "" ]
@@ -245,8 +243,6 @@ stdout of test 'systemfunctions` in dire
[ "sys", "avg", 0, "double", "avg" ]
[ "sys", "avg", 1, "month_interval", "" ]
[ "sys", "avg", 0, "double", "avg" ]
-[ "sys", "avg", 1, "sec_interval", "" ]
-[ "sys", "avg", 0, "double", "avg" ]
[ "sys", "avg", 1, "real", "" ]
[ "sys", "bbp", 0, "int", "create function sys.bbp ()\n returns
table (id int, name string,\n ttype string, count bigint, refcnt int, lrefcnt
int,\n location string, heat int, dirty string,\n status string, kind string)\n
external name bbp.get;" ]
[ "sys", "bbp", 1, "clob", "" ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
