Changeset: 942f382443c5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=942f382443c5
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: Oct2020
Log Message:
Upgrade fixes.
diffs (truncated from 834 to 300 lines):
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -2435,7 +2435,8 @@ sql_update_oct2020(Client c, mvc *sql, c
"GRANT EXECUTE ON AGGREGATE
median(INTERVAL DAY) TO PUBLIC;\n"
"create aggregate quantile(val INTERVAL
DAY, q DOUBLE) returns INTERVAL DAY\n"
" external name
\"aggr\".\"quantile\";\n"
- "GRANT EXECUTE ON AGGREGATE
quantile(INTERVAL DAY, DOUBLE) TO PUBLIC;\n");
+ "GRANT EXECUTE ON AGGREGATE
quantile(INTERVAL DAY, DOUBLE) TO PUBLIC;\n"
+ "update sys.functions set system = true
where system <> true and name in ('median', 'quantile') and schema_id = (select
id from sys.schemas where name = 'sys') and type = %d;\n", (int) F_AGGR);
pos += snprintf(buf + pos, bufsize - pos, "set schema
\"%s\";\n", prev_schema);
diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -4414,6 +4414,7 @@ GRANT EXECUTE ON AGGREGATE median(INTERV
create aggregate quantile(val INTERVAL DAY, q DOUBLE) returns INTERVAL DAY
external name "aggr"."quantile";
GRANT EXECUTE ON AGGREGATE quantile(INTERVAL DAY, DOUBLE) TO PUBLIC;
+update sys.functions set system = true where system <> true and name in
('median', 'quantile') and schema_id = (select id from sys.schemas where name =
'sys') and type = 3;
set schema "sys";
# MonetDB/SQL module loaded
diff --git
a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
@@ -4414,6 +4414,7 @@ GRANT EXECUTE ON AGGREGATE median(INTERV
create aggregate quantile(val INTERVAL DAY, q DOUBLE) returns INTERVAL DAY
external name "aggr"."quantile";
GRANT EXECUTE ON AGGREGATE quantile(INTERVAL DAY, DOUBLE) TO PUBLIC;
+update sys.functions set system = true where system <> true and name in
('median', 'quantile') and schema_id = (select id from sys.schemas where name =
'sys') and type = 3;
set schema "sys";
# MonetDB/SQL module loaded
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
@@ -3781,6 +3781,7 @@ GRANT EXECUTE ON AGGREGATE median(INTERV
create aggregate quantile(val INTERVAL DAY, q DOUBLE) returns INTERVAL DAY
external name "aggr"."quantile";
GRANT EXECUTE ON AGGREGATE quantile(INTERVAL DAY, DOUBLE) TO PUBLIC;
+update sys.functions set system = true where system <> true and name in
('median', 'quantile') and schema_id = (select id from sys.schemas where name =
'sys') and type = 3;
set schema "sys";
# MonetDB/SQL module loaded
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
@@ -3781,6 +3781,7 @@ GRANT EXECUTE ON AGGREGATE median(INTERV
create aggregate quantile(val INTERVAL DAY, q DOUBLE) returns INTERVAL DAY
external name "aggr"."quantile";
GRANT EXECUTE ON AGGREGATE quantile(INTERVAL DAY, DOUBLE) TO PUBLIC;
+update sys.functions set system = true where system <> true and name in
('median', 'quantile') and schema_id = (select id from sys.schemas where name =
'sys') and type = 3;
set schema "sys";
# MonetDB/SQL module loaded
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -4488,6 +4488,7 @@ GRANT EXECUTE ON AGGREGATE median(INTERV
create aggregate quantile(val INTERVAL DAY, q DOUBLE) returns INTERVAL DAY
external name "aggr"."quantile";
GRANT EXECUTE ON AGGREGATE quantile(INTERVAL DAY, DOUBLE) TO PUBLIC;
+update sys.functions set system = true where system <> true and name in
('median', 'quantile') and schema_id = (select id from sys.schemas where name =
'sys') and type = 3;
set schema "sys";
# MonetDB/SQL module loaded
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
@@ -3781,6 +3781,7 @@ GRANT EXECUTE ON AGGREGATE median(INTERV
create aggregate quantile(val INTERVAL DAY, q DOUBLE) returns INTERVAL DAY
external name "aggr"."quantile";
GRANT EXECUTE ON AGGREGATE quantile(INTERVAL DAY, DOUBLE) TO PUBLIC;
+update sys.functions set system = true where system <> true and name in
('median', 'quantile') and schema_id = (select id from sys.schemas where name =
'sys') and type = 3;
set schema "sys";
# MonetDB/SQL module loaded
diff --git
a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
@@ -4488,6 +4488,7 @@ GRANT EXECUTE ON AGGREGATE median(INTERV
create aggregate quantile(val INTERVAL DAY, q DOUBLE) returns INTERVAL DAY
external name "aggr"."quantile";
GRANT EXECUTE ON AGGREGATE quantile(INTERVAL DAY, DOUBLE) TO PUBLIC;
+update sys.functions set system = true where system <> true and name in
('median', 'quantile') and schema_id = (select id from sys.schemas where name =
'sys') and type = 3;
set schema "sys";
# MonetDB/SQL module loaded
diff --git a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
@@ -4419,6 +4419,7 @@ GRANT EXECUTE ON AGGREGATE median(INTERV
create aggregate quantile(val INTERVAL DAY, q DOUBLE) returns INTERVAL DAY
external name "aggr"."quantile";
GRANT EXECUTE ON AGGREGATE quantile(INTERVAL DAY, DOUBLE) TO PUBLIC;
+update sys.functions set system = true where system <> true and name in
('median', 'quantile') and schema_id = (select id from sys.schemas where name =
'sys') and type = 3;
set schema "sys";
# MonetDB/SQL module loaded
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
@@ -3786,6 +3786,7 @@ GRANT EXECUTE ON AGGREGATE median(INTERV
create aggregate quantile(val INTERVAL DAY, q DOUBLE) returns INTERVAL DAY
external name "aggr"."quantile";
GRANT EXECUTE ON AGGREGATE quantile(INTERVAL DAY, DOUBLE) TO PUBLIC;
+update sys.functions set system = true where system <> true and name in
('median', 'quantile') and schema_id = (select id from sys.schemas where name =
'sys') and type = 3;
set schema "sys";
# MonetDB/SQL module loaded
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
@@ -3786,6 +3786,7 @@ GRANT EXECUTE ON AGGREGATE median(INTERV
create aggregate quantile(val INTERVAL DAY, q DOUBLE) returns INTERVAL DAY
external name "aggr"."quantile";
GRANT EXECUTE ON AGGREGATE quantile(INTERVAL DAY, DOUBLE) TO PUBLIC;
+update sys.functions set system = true where system <> true and name in
('median', 'quantile') and schema_id = (select id from sys.schemas where name =
'sys') and type = 3;
set schema "sys";
# MonetDB/SQL module loaded
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
@@ -4493,6 +4493,7 @@ GRANT EXECUTE ON AGGREGATE median(INTERV
create aggregate quantile(val INTERVAL DAY, q DOUBLE) returns INTERVAL DAY
external name "aggr"."quantile";
GRANT EXECUTE ON AGGREGATE quantile(INTERVAL DAY, DOUBLE) TO PUBLIC;
+update sys.functions set system = true where system <> true and name in
('median', 'quantile') and schema_id = (select id from sys.schemas where name =
'sys') and type = 3;
set schema "sys";
# MonetDB/SQL module loaded
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
@@ -991,8 +991,6 @@ create aggregate corr(e1 bigint, e2 bigi
create aggregate corr(e1 double, e2 double) returns double external name
"aggr"."corr";
create aggregate corr(e1 hugeint, e2 hugeint) returns double external name
"aggr"."corr";
create aggregate corr(e1 integer, e2 integer) returns double external name
"aggr"."corr";
-create aggregate corr(e1 interval month, e2 interval month) returns double
external name "aggr"."corr";
-create aggregate corr(e1 interval second, e2 interval second) returns double
external name "aggr"."corr";
create aggregate corr(e1 real, e2 real) returns double external name
"aggr"."corr";
create aggregate corr(e1 smallint, e2 smallint) returns double external name
"aggr"."corr";
create aggregate corr(e1 tinyint, e2 tinyint) returns double external name
"aggr"."corr";
@@ -1000,8 +998,6 @@ create window corr(e1 bigint, e2 bigint)
create window corr(e1 double, e2 double) returns double external name
"sql"."corr";
create window corr(e1 hugeint, e2 hugeint) returns double external name
"sql"."corr";
create window corr(e1 integer, e2 integer) returns double external name
"sql"."corr";
-create window corr(e1 interval month, e2 interval month) returns double
external name "sql"."corr";
-create window corr(e1 interval second, e2 interval second) returns double
external name "sql"."corr";
create window corr(e1 real, e2 real) returns double external name "sql"."corr";
create window corr(e1 smallint, e2 smallint) returns double external name
"sql"."corr";
create window corr(e1 tinyint, e2 tinyint) returns double external name
"sql"."corr";
@@ -1009,8 +1005,6 @@ create aggregate covar_pop(e1 bigint, e2
create aggregate covar_pop(e1 double, e2 double) returns double external name
"aggr"."covariancep";
create aggregate covar_pop(e1 hugeint, e2 hugeint) returns double external
name "aggr"."covariancep";
create aggregate covar_pop(e1 integer, e2 integer) returns double external
name "aggr"."covariancep";
-create aggregate covar_pop(e1 interval month, e2 interval month) returns
double external name "aggr"."covariancep";
-create aggregate covar_pop(e1 interval second, e2 interval second) returns
double external name "aggr"."covariancep";
create aggregate covar_pop(e1 real, e2 real) returns double external name
"aggr"."covariancep";
create aggregate covar_pop(e1 smallint, e2 smallint) returns double external
name "aggr"."covariancep";
create aggregate covar_pop(e1 tinyint, e2 tinyint) returns double external
name "aggr"."covariancep";
@@ -1018,8 +1012,6 @@ create window covar_pop(e1 bigint, e2 bi
create window covar_pop(e1 double, e2 double) returns double external name
"sql"."covariancep";
create window covar_pop(e1 hugeint, e2 hugeint) returns double external name
"sql"."covariancep";
create window covar_pop(e1 integer, e2 integer) returns double external name
"sql"."covariancep";
-create window covar_pop(e1 interval month, e2 interval month) returns double
external name "sql"."covariancep";
-create window covar_pop(e1 interval second, e2 interval second) returns double
external name "sql"."covariancep";
create window covar_pop(e1 real, e2 real) returns double external name
"sql"."covariancep";
create window covar_pop(e1 smallint, e2 smallint) returns double external name
"sql"."covariancep";
create window covar_pop(e1 tinyint, e2 tinyint) returns double external name
"sql"."covariancep";
@@ -1027,8 +1019,6 @@ create aggregate covar_samp(e1 bigint, e
create aggregate covar_samp(e1 double, e2 double) returns double external name
"aggr"."covariance";
create aggregate covar_samp(e1 hugeint, e2 hugeint) returns double external
name "aggr"."covariance";
create aggregate covar_samp(e1 integer, e2 integer) returns double external
name "aggr"."covariance";
-create aggregate covar_samp(e1 interval month, e2 interval month) returns
double external name "aggr"."covariance";
-create aggregate covar_samp(e1 interval second, e2 interval second) returns
double external name "aggr"."covariance";
create aggregate covar_samp(e1 real, e2 real) returns double external name
"aggr"."covariance";
create aggregate covar_samp(e1 smallint, e2 smallint) returns double external
name "aggr"."covariance";
create aggregate covar_samp(e1 tinyint, e2 tinyint) returns double external
name "aggr"."covariance";
@@ -1036,8 +1026,6 @@ create window covar_samp(e1 bigint, e2 b
create window covar_samp(e1 double, e2 double) returns double external name
"sql"."covariance";
create window covar_samp(e1 hugeint, e2 hugeint) returns double external name
"sql"."covariance";
create window covar_samp(e1 integer, e2 integer) returns double external name
"sql"."covariance";
-create window covar_samp(e1 interval month, e2 interval month) returns double
external name "sql"."covariance";
-create window covar_samp(e1 interval second, e2 interval second) returns
double external name "sql"."covariance";
create window covar_samp(e1 real, e2 real) returns double external name
"sql"."covariance";
create window covar_samp(e1 smallint, e2 smallint) returns double external
name "sql"."covariance";
create window covar_samp(e1 tinyint, e2 tinyint) returns double external name
"sql"."covariance";
@@ -1338,8 +1326,6 @@ create aggregate stddev_pop(val bigint)
create aggregate stddev_pop(val double) returns double external name
"aggr"."stdevp";
create aggregate stddev_pop(val hugeint) returns double external name
"aggr"."stdevp";
create aggregate stddev_pop(val integer) returns double external name
"aggr"."stdevp";
-create aggregate stddev_pop(val interval month) returns double external name
"aggr"."stdevp";
-create aggregate stddev_pop(val interval second) returns double external name
"aggr"."stdevp";
create aggregate stddev_pop(val real) returns double external name
"aggr"."stdevp";
create aggregate stddev_pop(val smallint) returns double external name
"aggr"."stdevp";
create aggregate stddev_pop(val tinyint) returns double external name
"aggr"."stdevp";
@@ -1347,8 +1333,6 @@ create window stddev_pop(val bigint) ret
create window stddev_pop(val double) returns double external name
"sql"."stdevp";
create window stddev_pop(val hugeint) returns double external name
"sql"."stdevp";
create window stddev_pop(val integer) returns double external name
"sql"."stdevp";
-create window stddev_pop(val interval month) returns double external name
"sql"."stdevp";
-create window stddev_pop(val interval second) returns double external name
"sql"."stdevp";
create window stddev_pop(val real) returns double external name "sql"."stdevp";
create window stddev_pop(val smallint) returns double external name
"sql"."stdevp";
create window stddev_pop(val tinyint) returns double external name
"sql"."stdevp";
@@ -1356,8 +1340,6 @@ create aggregate stddev_samp(val bigint)
create aggregate stddev_samp(val double) returns double external name
"aggr"."stdev";
create aggregate stddev_samp(val hugeint) returns double external name
"aggr"."stdev";
create aggregate stddev_samp(val integer) returns double external name
"aggr"."stdev";
-create aggregate stddev_samp(val interval month) returns double external name
"aggr"."stdev";
-create aggregate stddev_samp(val interval second) returns double external name
"aggr"."stdev";
create aggregate stddev_samp(val real) returns double external name
"aggr"."stdev";
create aggregate stddev_samp(val smallint) returns double external name
"aggr"."stdev";
create aggregate stddev_samp(val tinyint) returns double external name
"aggr"."stdev";
@@ -1365,8 +1347,6 @@ create window stddev_samp(val bigint) re
create window stddev_samp(val double) returns double external name
"sql"."stdev";
create window stddev_samp(val hugeint) returns double external name
"sql"."stdev";
create window stddev_samp(val integer) returns double external name
"sql"."stdev";
-create window stddev_samp(val interval month) returns double external name
"sql"."stdev";
-create window stddev_samp(val interval second) returns double external name
"sql"."stdev";
create window stddev_samp(val real) returns double external name "sql"."stdev";
create window stddev_samp(val smallint) returns double external name
"sql"."stdev";
create window stddev_samp(val tinyint) returns double external name
"sql"."stdev";
@@ -1393,8 +1373,6 @@ create aggregate var_pop(val bigint) ret
create aggregate var_pop(val double) returns double external name
"aggr"."variancep";
create aggregate var_pop(val hugeint) returns double external name
"aggr"."variancep";
create aggregate var_pop(val integer) returns double external name
"aggr"."variancep";
-create aggregate var_pop(val interval month) returns double external name
"aggr"."variancep";
-create aggregate var_pop(val interval second) returns double external name
"aggr"."variancep";
create aggregate var_pop(val real) returns double external name
"aggr"."variancep";
create aggregate var_pop(val smallint) returns double external name
"aggr"."variancep";
create aggregate var_pop(val tinyint) returns double external name
"aggr"."variancep";
@@ -1402,8 +1380,6 @@ create window var_pop(val bigint) return
create window var_pop(val double) returns double external name
"sql"."variancep";
create window var_pop(val hugeint) returns double external name
"sql"."variancep";
create window var_pop(val integer) returns double external name
"sql"."variancep";
-create window var_pop(val interval month) returns double external name
"sql"."variancep";
-create window var_pop(val interval second) returns double external name
"sql"."variancep";
create window var_pop(val real) returns double external name "sql"."variancep";
create window var_pop(val smallint) returns double external name
"sql"."variancep";
create window var_pop(val tinyint) returns double external name
"sql"."variancep";
@@ -1411,8 +1387,6 @@ create aggregate var_samp(val bigint) re
create aggregate var_samp(val double) returns double external name
"aggr"."variance";
create aggregate var_samp(val hugeint) returns double external name
"aggr"."variance";
create aggregate var_samp(val integer) returns double external name
"aggr"."variance";
-create aggregate var_samp(val interval month) returns double external name
"aggr"."variance";
-create aggregate var_samp(val interval second) returns double external name
"aggr"."variance";
create aggregate var_samp(val real) returns double external name
"aggr"."variance";
create aggregate var_samp(val smallint) returns double external name
"aggr"."variance";
create aggregate var_samp(val tinyint) returns double external name
"aggr"."variance";
@@ -1420,8 +1394,6 @@ create window var_samp(val bigint) retur
create window var_samp(val double) returns double external name
"sql"."variance";
create window var_samp(val hugeint) returns double external name
"sql"."variance";
create window var_samp(val integer) returns double external name
"sql"."variance";
-create window var_samp(val interval month) returns double external name
"sql"."variance";
-create window var_samp(val interval second) returns double external name
"sql"."variance";
create window var_samp(val real) returns double external name "sql"."variance";
create window var_samp(val smallint) returns double external name
"sql"."variance";
create window var_samp(val tinyint) returns double external name
"sql"."variance";
@@ -2280,6 +2252,7 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", ">=", "SYSTEM", ">=", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "boolean", 1, 0, "out", "arg_1", "any",
0, 0, "in", "arg_2", "any", 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", "abbrev", "SYSTEM", "create
function \"abbrev\" (p inet) returns clob external name inet.\"abbrev\";",
"inet", "MAL", "Scalar function", false, false, false, true,
"result", "clob", 0, 0, "out", "p", "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, NULL, NULL, NULL, NULL,
NULL ]
[ "sys.functions", "sys", "abs", "SYSTEM", "abs", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "bigint", 64, 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 ]
+[ "sys.functions", "sys", "abs", "SYSTEM", "abs", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "day_interval", 4, 0, "out", "arg_1",
"day_interval", 4, 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", "abs", "SYSTEM", "abs", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "decimal", 2, 0, "out", "arg_1",
"decimal", 2, 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", "abs", "SYSTEM", "abs", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "decimal", 4, 0, "out", "arg_1",
"decimal", 4, 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", "abs", "SYSTEM", "abs", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "decimal", 9, 0, "out", "arg_1",
"decimal", 9, 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 ]
@@ -2288,7 +2261,7 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "abs", "SYSTEM", "abs", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "double", 53, 0, "out", "arg_1",
"double", 53, 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", "abs", "SYSTEM", "abs", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "hugeint", 128, 0, "out", "arg_1",
"hugeint", 128, 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", "abs", "SYSTEM", "abs", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "int", 32, 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.functions", "sys", "abs", "SYSTEM", "abs", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "month_interval", 32, 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.functions", "sys", "abs", "SYSTEM", "abs", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "month_interval", 3, 0, "out", "arg_1",
"month_interval", 3, 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", "abs", "SYSTEM", "abs", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "real", 24, 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.functions", "sys", "abs", "SYSTEM", "abs", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "sec_interval", 13, 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.functions", "sys", "abs", "SYSTEM", "abs", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "smallint", 16, 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 ]
@@ -2425,8 +2398,6 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "corr", "SYSTEM", "create aggregate
corr(e1 double, e2 double) returns double external name \"aggr\".\"corr\";",
"aggr", "MAL", "Aggregate function", false, false, false, true,
"result", "double", 53, 0, "out", "e1", "double",
53, 0, "in", "e2", "double", 53, 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", "corr", "SYSTEM", "create aggregate
corr(e1 hugeint, e2 hugeint) returns double external name \"aggr\".\"corr\";",
"aggr", "MAL", "Aggregate function", false, false, false, true,
"result", "double", 53, 0, "out", "e1", "hugeint",
128, 0, "in", "e2", "hugeint", 128, 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", "corr", "SYSTEM", "create aggregate
corr(e1 integer, e2 integer) returns double external name \"aggr\".\"corr\";",
"aggr", "MAL", "Aggregate function", false, false, false, true,
"result", "double", 53, 0, "out", "e1", "int", 32,
0, "in", "e2", "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 ]
-[ "sys.functions", "sys", "corr", "SYSTEM", "create aggregate
corr(e1 interval month, e2 interval month) returns double external name
\"aggr\".\"corr\";", "aggr", "MAL", "Aggregate function", false, false,
false, true, "result", "double", 53, 0, "out", "e1",
"month_interval", 3, 0, "in", "e2", "month_interval",
3, 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", "corr", "SYSTEM", "create aggregate
corr(e1 interval second, e2 interval second) returns double external name
\"aggr\".\"corr\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, "result", "double", 53, 0, "out",
"e1", "sec_interval", 13, 0, "in", "e2", "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 ]
[ "sys.functions", "sys", "corr", "SYSTEM", "create aggregate
corr(e1 real, e2 real) returns double external name \"aggr\".\"corr\";",
"aggr", "MAL", "Aggregate function", false, false, false, true,
"result", "double", 53, 0, "out", "e1", "real", 24,
0, "in", "e2", "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 ]
[ "sys.functions", "sys", "corr", "SYSTEM", "create aggregate
corr(e1 smallint, e2 smallint) returns double external name
\"aggr\".\"corr\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, "result", "double", 53, 0, "out",
"e1", "smallint", 16, 0, "in", "e2", "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 ]
[ "sys.functions", "sys", "corr", "SYSTEM", "create aggregate
corr(e1 tinyint, e2 tinyint) returns double external name \"aggr\".\"corr\";",
"aggr", "MAL", "Aggregate function", false, false, false, true,
"result", "double", 53, 0, "out", "e1", "tinyint",
8, 0, "in", "e2", "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 ]
@@ -2434,8 +2405,6 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "corr", "SYSTEM", "create window corr(e1
double, e2 double) returns double external name \"sql\".\"corr\";", "sql",
"MAL", "Analytic function", false, false, false, true, "result",
"double", 53, 0, "out", "e1", "double", 53, 0,
"in", "e2", "double", 53, 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", "corr", "SYSTEM", "create window corr(e1
hugeint, e2 hugeint) returns double external name \"sql\".\"corr\";", "sql",
"MAL", "Analytic function", false, false, false, true, "result",
"double", 53, 0, "out", "e1", "hugeint", 128, 0,
"in", "e2", "hugeint", 128, 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", "corr", "SYSTEM", "create window corr(e1
integer, e2 integer) returns double external name \"sql\".\"corr\";", "sql",
"MAL", "Analytic function", false, false, false, true, "result",
"double", 53, 0, "out", "e1", "int", 32, 0, "in",
"e2", "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
]
-[ "sys.functions", "sys", "corr", "SYSTEM", "create window corr(e1
interval month, e2 interval month) returns double external name
\"sql\".\"corr\";", "sql", "MAL", "Analytic function", false, false,
false, true, "result", "double", 53, 0, "out", "e1",
"month_interval", 3, 0, "in", "e2", "month_interval",
3, 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", "corr", "SYSTEM", "create window corr(e1
interval second, e2 interval second) returns double external name
\"sql\".\"corr\";", "sql", "MAL", "Analytic function", false, false,
false, true, "result", "double", 53, 0, "out", "e1",
"sec_interval", 13, 0, "in", "e2", "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 ]
[ "sys.functions", "sys", "corr", "SYSTEM", "create window corr(e1
real, e2 real) returns double external name \"sql\".\"corr\";", "sql", "MAL",
"Analytic function", false, false, false, true, "result",
"double", 53, 0, "out", "e1", "real", 24, 0, "in",
"e2", "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
]
[ "sys.functions", "sys", "corr", "SYSTEM", "create window corr(e1
smallint, e2 smallint) returns double external name \"sql\".\"corr\";", "sql",
"MAL", "Analytic function", false, false, false, true, "result",
"double", 53, 0, "out", "e1", "smallint", 16, 0,
"in", "e2", "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 ]
[ "sys.functions", "sys", "corr", "SYSTEM", "create window corr(e1
tinyint, e2 tinyint) returns double external name \"sql\".\"corr\";", "sql",
"MAL", "Analytic function", false, false, false, true, "result",
"double", 53, 0, "out", "e1", "tinyint", 8, 0,
"in", "e2", "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 ]
@@ -2452,8 +2421,6 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "covar_pop", "SYSTEM", "create
aggregate covar_pop(e1 double, e2 double) returns double external name
\"aggr\".\"covariancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, "result", "double", 53, 0, "out",
"e1", "double", 53, 0, "in", "e2", "double", 53,
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 ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
