Changeset: 1109b8876a59 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1109b8876a59
Modified Files:
sql/test/emptydb/Tests/check.SQL.py
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
Branch: system-functions
Log Message:
Normalize output for system functions.
This makes the output compatible with upgraded databases.
diffs (truncated from 8297 to 300 lines):
diff --git a/sql/test/emptydb/Tests/check.SQL.py
b/sql/test/emptydb/Tests/check.SQL.py
--- a/sql/test/emptydb/Tests/check.SQL.py
+++ b/sql/test/emptydb/Tests/check.SQL.py
@@ -53,7 +53,7 @@ for res in re.finditer(r'(?<=\n)(?:creat
nout += out[pos:res.start(0)] + wsre.sub(' ', res.group(0)).replace('( ',
'(').replace(' )', ')')
pos = res.end(0)
nout += out[pos:]
-out = nout
+out = nout.replace('\ncreate system ', '\ncreate ')
sys.stdout.write(out)
sys.stderr.write(err)
@@ -84,7 +84,7 @@ MAXARGS = 16
# columns of the args table we're interested in
args = ['name', 'type', 'type_digits', 'type_scale', 'inout']
-out += r"select s.name, f.name, case f.system when true then 'SYSTEM' else ''
end as system, replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func,
'--.*\n', '', ''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')')
as query, f.mod, fl.language_name, ft.function_type_name, f.side_effect,
f.varres, f.vararg"
+out += r"select s.name, f.name, case f.system when true then 'SYSTEM' else ''
end as system,
replace(replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func,
'--.*\n', '', ''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )',
')'), 'create system ', 'create ') as query, f.mod, fl.language_name,
ft.function_type_name, f.side_effect, f.varres, f.vararg"
for i in range(0, MAXARGS):
for a in args[:-1]:
out += ", a%d.%s as %s%d" % (i, a, a, i)
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
@@ -941,365 +941,365 @@ create view sys.tablestoragemodel as sel
create view sys.tracelog as select * from sys.tracelog();
SELECT u."name" AS "name", ui."fullname", ui."default_schema" FROM db_users()
AS u LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name" ;
create view sys.var_values (var_name, value) as select 'cache' as var_name,
convert(cache, varchar(10)) as value union all select 'current_role',
current_role union all select 'current_schema', current_schema union all select
'current_timezone', current_timezone union all select 'current_user',
current_user union all select 'debug', debug union all select 'history',
history union all select 'last_id', last_id union all select 'optimizer',
optimizer union all select 'pi', pi() union all select 'rowcnt', rowcnt;
-create system function "abbrev" (p inet) returns clob external name
inet."abbrev";
-create system function alpha(pdec double, pradius double) returns double
external name sql.alpha;
-create system procedure sys.analyze(minmax int, "sample" bigint) external name
sql.analyze;
-create system procedure sys.analyze(minmax int, "sample" bigint, sch string)
external name sql.analyze;
-create system procedure sys.analyze(minmax int, "sample" bigint, sch string,
tbl string) external name sql.analyze;
-create system procedure sys.analyze(minmax int, "sample" bigint, sch string,
tbl string, col string) external name sql.analyze;
-create system 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;
-create system function "broadcast" (p inet) returns inet external name
inet."broadcast";
-create system procedure sys.clearrejects() external name
sql.copy_rejects_clear;
-create system function sys.columnsize(nme string, i bigint, d bigint) returns
bigint begin case when nme = 'boolean' then return i; when nme = 'char' then
return 2*i; when nme = 'smallint' then return 2 * i; when nme = 'int' then
return 4 * i; when nme = 'bigint' then return 8 * i; when nme = 'hugeint' then
return 16 * i; when nme = 'timestamp' then return 8 * i; when nme = 'varchar'
then case when cast(d as bigint) << 8 then return i; when cast(d as bigint) <<
16 then return 2 * i; when cast(d as bigint) << 32 then return 4 * i; else
return 8 * i; end case; else return 8 * i; end case; end;
-create system function contains(a geometry, x double, y double) returns
boolean external name geom."Contains";
-create system aggregate corr(e1 bigint, e2 bigint) returns double external
name "aggr"."corr";
-create system aggregate corr(e1 double, e2 double) returns double external
name "aggr"."corr";
-create system aggregate corr(e1 integer, e2 integer) returns double external
name "aggr"."corr";
-create system aggregate corr(e1 real, e2 real) returns double external name
"aggr"."corr";
-create system aggregate corr(e1 smallint, e2 smallint) returns double external
name "aggr"."corr";
-create system aggregate corr(e1 tinyint, e2 tinyint) returns double external
name "aggr"."corr";
-create system procedure sys.createorderindex(sys string, tab string, col
string) external name sql.createorderindex;
-create system function date_to_str(d date, format string) returns string
external name mtime."date_to_str";
+create function "abbrev" (p inet) returns clob external name inet."abbrev";
+create function alpha(pdec double, pradius double) returns double external
name sql.alpha;
+create procedure sys.analyze(minmax int, "sample" bigint) external name
sql.analyze;
+create procedure sys.analyze(minmax int, "sample" bigint, sch string) external
name sql.analyze;
+create procedure sys.analyze(minmax int, "sample" bigint, sch string, tbl
string) external name sql.analyze;
+create procedure sys.analyze(minmax int, "sample" bigint, sch string, tbl
string, col string) external name sql.analyze;
+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;
+create function "broadcast" (p inet) returns inet external name
inet."broadcast";
+create procedure sys.clearrejects() external name sql.copy_rejects_clear;
+create function sys.columnsize(nme string, i bigint, d bigint) returns bigint
begin case when nme = 'boolean' then return i; when nme = 'char' then return
2*i; when nme = 'smallint' then return 2 * i; when nme = 'int' then return 4 *
i; when nme = 'bigint' then return 8 * i; when nme = 'hugeint' then return 16 *
i; when nme = 'timestamp' then return 8 * i; when nme = 'varchar' then case
when cast(d as bigint) << 8 then return i; when cast(d as bigint) << 16 then
return 2 * i; when cast(d as bigint) << 32 then return 4 * i; else return 8 *
i; end case; else return 8 * i; end case; end;
+create function contains(a geometry, x double, y double) returns boolean
external name geom."Contains";
+create aggregate corr(e1 bigint, e2 bigint) returns double external name
"aggr"."corr";
+create aggregate corr(e1 double, e2 double) returns double external name
"aggr"."corr";
+create aggregate corr(e1 integer, e2 integer) 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";
+create procedure sys.createorderindex(sys string, tab string, col string)
external name sql.createorderindex;
+create function date_to_str(d date, format string) returns string external
name mtime."date_to_str";
CREATE FUNCTION db_users () RETURNS TABLE(name varchar(2048)) EXTERNAL NAME
sql.db_users;
-create system function sys.debug(debug int) returns integer external name
mdb."setDebug";
-create system function degrees(r double) returns double return r*180/pi();
-create system function dependencies_columns_on_functions() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
c.name, f.name, 'DEP_FUNC' from functions as f, columns as c, dependencies as
dep where c.id = dep.id and f.id = dep.depend_id and dep.depend_type = 7);
-create system function dependencies_columns_on_indexes() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
c.name, i.name, 'DEP_INDEX' from columns as c, objects as kc, idxs as i where
kc."name" = c.name and kc.id = i.id and c.table_id = i.table_id and i.name not
in (select name from keys));
-create system function dependencies_columns_on_keys() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
c.name, k.name, 'DEP_KEY' from columns as c, objects as kc, keys as k where
kc."name" = c.name and kc.id = k.id and k.table_id = c.table_id and k.rkey =
-1);
-create system function dependencies_columns_on_triggers() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
c.name, tri.name, 'DEP_TRIGGER' from columns as c, triggers as tri,
dependencies as dep where dep.id = c.id and dep.depend_id =tri.id and
dep.depend_type = 8);
-create system function dependencies_columns_on_views() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
c.name, v.name, 'DEP_VIEW' from columns as c, tables as v, dependencies as dep
where c.id = dep.id and v.id = dep.depend_id and dep.depend_type = 5 and v.type
= 1);
-create system function dependencies_functions_on_functions() returns table
(sch varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
f1.name, f2.name, 'DEP_FUNC' from functions as f1, functions as f2,
dependencies as dep where f1.id = dep.id and f2.id = dep.depend_id and
dep.depend_type = 7);
-create system function dependencies_functions_os_triggers() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
f.name, tri.name, 'DEP_TRIGGER' from functions as f, triggers as tri,
dependencies as dep where dep.id = f.id and dep.depend_id =tri.id and
dep.depend_type = 8);
-create system function dependencies_keys_on_foreignkeys() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
k.name, fk.name, 'DEP_FKEY' from keys as k, keys as fk where fk.rkey = k.id);
-create system function dependencies_owners_on_schemas() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
a.name, s.name, 'DEP_SCHEMA' from schemas as s, auths a where s.owner = a.id);
-create system function dependencies_schemas_on_users() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
s.name, u.name, 'DEP_USER' from schemas as s, users u where u.default_schema =
s.id);
-create system function dependencies_tables_on_foreignkeys() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
t.name, fk.name, 'DEP_FKEY' from tables as t, keys as k, keys as fk where
fk.rkey = k.id and k.table_id = t.id);
-create system function dependencies_tables_on_functions() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
t.name, f.name, 'DEP_FUNC' from functions as f, tables as t, dependencies as
dep where t.id = dep.id and f.id = dep.depend_id and dep.depend_type = 7 and
t.type = 0);
-create system function dependencies_tables_on_indexes() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
t.name, i.name, 'DEP_INDEX' from tables as t, idxs as i where i.table_id = t.id
and i.name not in (select name from keys) and t.type = 0);
-create system function dependencies_tables_on_triggers() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table ((select
t.name, tri.name, 'DEP_TRIGGER' from tables as t, triggers as tri where
tri.table_id = t.id) union (select t.name, tri.name, 'DEP_TRIGGER' from
triggers tri, tables t, dependencies dep where dep.id = t.id and dep.depend_id
=tri.id and dep.depend_type = 8));
-create system function dependencies_tables_on_views() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
t.name, v.name, 'DEP_VIEW' from tables as t, tables as v, dependencies as dep
where t.id = dep.id and v.id = dep.depend_id and dep.depend_type = 5 and v.type
= 1);
-create system function dependencies_views_on_functions() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
v.name, f.name, 'DEP_FUNC' from functions as f, tables as v, dependencies as
dep where v.id = dep.id and f.id = dep.depend_id and dep.depend_type = 7 and
v.type = 1);
-create system function dependencies_views_on_triggers() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
v.name, tri.name, 'DEP_TRIGGER' from tables as v, triggers as tri, dependencies
as dep where dep.id = v.id and dep.depend_id =tri.id and dep.depend_type = 8
and v.type = 1);
-create system procedure sys.droporderindex(sys string, tab string, col string)
external name sql.droporderindex;
+create function sys.debug(debug int) returns integer external name
mdb."setDebug";
+create function degrees(r double) returns double return r*180/pi();
+create function dependencies_columns_on_functions() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
c.name, f.name, 'DEP_FUNC' from functions as f, columns as c, dependencies as
dep where c.id = dep.id and f.id = dep.depend_id and dep.depend_type = 7);
+create function dependencies_columns_on_indexes() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
c.name, i.name, 'DEP_INDEX' from columns as c, objects as kc, idxs as i where
kc."name" = c.name and kc.id = i.id and c.table_id = i.table_id and i.name not
in (select name from keys));
+create function dependencies_columns_on_keys() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
c.name, k.name, 'DEP_KEY' from columns as c, objects as kc, keys as k where
kc."name" = c.name and kc.id = k.id and k.table_id = c.table_id and k.rkey =
-1);
+create function dependencies_columns_on_triggers() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
c.name, tri.name, 'DEP_TRIGGER' from columns as c, triggers as tri,
dependencies as dep where dep.id = c.id and dep.depend_id =tri.id and
dep.depend_type = 8);
+create function dependencies_columns_on_views() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
c.name, v.name, 'DEP_VIEW' from columns as c, tables as v, dependencies as dep
where c.id = dep.id and v.id = dep.depend_id and dep.depend_type = 5 and v.type
= 1);
+create function dependencies_functions_on_functions() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
f1.name, f2.name, 'DEP_FUNC' from functions as f1, functions as f2,
dependencies as dep where f1.id = dep.id and f2.id = dep.depend_id and
dep.depend_type = 7);
+create function dependencies_functions_os_triggers() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
f.name, tri.name, 'DEP_TRIGGER' from functions as f, triggers as tri,
dependencies as dep where dep.id = f.id and dep.depend_id =tri.id and
dep.depend_type = 8);
+create function dependencies_keys_on_foreignkeys() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
k.name, fk.name, 'DEP_FKEY' from keys as k, keys as fk where fk.rkey = k.id);
+create function dependencies_owners_on_schemas() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
a.name, s.name, 'DEP_SCHEMA' from schemas as s, auths a where s.owner = a.id);
+create function dependencies_schemas_on_users() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
s.name, u.name, 'DEP_USER' from schemas as s, users u where u.default_schema =
s.id);
+create function dependencies_tables_on_foreignkeys() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
t.name, fk.name, 'DEP_FKEY' from tables as t, keys as k, keys as fk where
fk.rkey = k.id and k.table_id = t.id);
+create function dependencies_tables_on_functions() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
t.name, f.name, 'DEP_FUNC' from functions as f, tables as t, dependencies as
dep where t.id = dep.id and f.id = dep.depend_id and dep.depend_type = 7 and
t.type = 0);
+create function dependencies_tables_on_indexes() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
t.name, i.name, 'DEP_INDEX' from tables as t, idxs as i where i.table_id = t.id
and i.name not in (select name from keys) and t.type = 0);
+create function dependencies_tables_on_triggers() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table ((select
t.name, tri.name, 'DEP_TRIGGER' from tables as t, triggers as tri where
tri.table_id = t.id) union (select t.name, tri.name, 'DEP_TRIGGER' from
triggers tri, tables t, dependencies dep where dep.id = t.id and dep.depend_id
=tri.id and dep.depend_type = 8));
+create function dependencies_tables_on_views() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
t.name, v.name, 'DEP_VIEW' from tables as t, tables as v, dependencies as dep
where t.id = dep.id and v.id = dep.depend_id and dep.depend_type = 5 and v.type
= 1);
+create function dependencies_views_on_functions() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
v.name, f.name, 'DEP_FUNC' from functions as f, tables as v, dependencies as
dep where v.id = dep.id and f.id = dep.depend_id and dep.depend_type = 7 and
v.type = 1);
+create function dependencies_views_on_triggers() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
v.name, tri.name, 'DEP_TRIGGER' from tables as v, triggers as tri, dependencies
as dep where dep.id = v.id and dep.depend_id =tri.id and dep.depend_type = 8
and v.type = 1);
+create procedure sys.droporderindex(sys string, tab string, col string)
external name sql.droporderindex;
CREATE FUNCTION env () RETURNS TABLE(name varchar(1024), value varchar(2048))
EXTERNAL NAME sql.sql_environment;
-create system function sys."epoch"(sec bigint) returns timestamp external name
timestamp."epoch";
-create system function sys."epoch"(sec int) returns timestamp external name
timestamp."epoch";
-create system function sys."epoch"(ts timestamp with time zone) returns int
external name timestamp."epoch";
-create system function sys."epoch"(ts timestamp) returns int external name
timestamp."epoch";
-create system procedure sys.evalalgebra(ra_stmt string, opt bool) external
name sql."evalAlgebra";
-create system procedure fitsattach(fname string) external name fits.attach;
-create system procedure fitsload(tname string) external name fits.load;
-create system procedure sys.flush_log () external name sql."flush_log";
-create system function fuse(one integer, two integer) returns bigint external
name udf.fuse;
-create system function fuse(one smallint, two smallint) returns integer
external name udf.fuse;
-create system function fuse(one tinyint, two tinyint) returns smallint
external name udf.fuse;
-create system function sys.generate_series(first bigint, last bigint) returns
table (value bigint) external name generator.series;
-create system function sys.generate_series(first bigint, last bigint, stepsize
bigint) returns table (value bigint) external name generator.series;
-create system function sys.generate_series(first decimal(10,2), last
decimal(10,2), stepsize decimal(10,2)) returns table (value decimal(10,2))
external name generator.series;
-create system function sys.generate_series(first double, last double, stepsize
double) returns table (value double) external name generator.series;
-create system function sys.generate_series(first int, last int) returns table
(value int) external name generator.series;
-create system function sys.generate_series(first int, last int, stepsize int)
returns table (value int) external name generator.series;
-create system function sys.generate_series(first real, last real, stepsize
real) returns table (value real) external name generator.series;
-create system function sys.generate_series(first smallint, last smallint)
returns table (value smallint) external name generator.series;
-create system function sys.generate_series(first smallint, last smallint,
stepsize smallint) returns table (value smallint) external name
generator.series;
-create system function sys.generate_series(first timestamp, last timestamp,
stepsize interval second) returns table (value timestamp) external name
generator.series;
-create system function sys.generate_series(first tinyint, last tinyint)
returns table (value tinyint) external name generator.series;
-create system function sys.generate_series(first tinyint, last tinyint,
stepsize tinyint) returns table (value tinyint) external name generator.series;
-create system function geometrytype(geom geometry) returns string external
name geom."GeometryType1";
-create system function get_type(info integer, format integer) returns string
external name geom."getType";
-create system function getanchor(theurl url) returns string external name
url."getAnchor";
-create system function getbasename(theurl url) returns string external name
url."getBasename";
-create system function getcontent(theurl url) returns string external name
url."getContent";
-create system function getcontext(theurl url) returns string external name
url."getContext";
-create system function getdomain(theurl url) returns string external name
url."getDomain";
-create system function getextension(theurl url) returns string external name
url."getExtension";
-create system function getfile(theurl url) returns string external name
url."getFile";
-create system function gethost(theurl url) returns string external name
url."getHost";
-create system function getport(theurl url) returns string external name
url."getPort";
-create system function getproj4(srid_in integer) returns string begin return
select proj4text from spatial_ref_sys where srid=srid_in; end;
-create system function getprotocol(theurl url) returns string external name
url."getProtocol";
-create system function getquery(theurl url) returns string external name
url."getQuery";
-create system function getroboturl(theurl url) returns string external name
url."getRobotURL";
-create system function getuser(theurl url) returns string external name
url."getUser";
-create system aggregate sys.group_concat(str string) returns string external
name "aggr"."str_group_concat";
-create system aggregate sys.group_concat(str string, sep string) returns
string external name "aggr"."str_group_concat";
-create system function has_m(info integer) returns integer external name
geom."hasM";
-create system function has_z(info integer) returns integer external name
geom."hasZ";
-create system function sys.hashsize(b boolean, i bigint) returns bigint begin
if b = true then return 8 * i; end if; return 0; end;
-create system function sys.heapsize(tpe string, i bigint, w int) returns
bigint begin if tpe <> 'varchar' and tpe <> 'clob' then return 0; end if;
return 10240 + i * w; end;
-create system function "host" (p inet) returns clob external name inet."host";
-create system function "hostmask" (p inet) returns inet external name
inet."hostmask";
-create system filter function "ilike"(val string, pat string) external name
algebra."ilike";
-create system filter function "ilike"(val string, pat string, esc string)
external name algebra."ilike";
-create system function sys.imprintsize(i bigint, nme string) returns bigint
begin if nme = 'boolean' or nme = 'tinyint' or nme = 'smallint' or nme = 'int'
or nme = 'bigint' or nme = 'hugeint' or nme = 'decimal' or nme = 'date' or nme
= 'timestamp' or nme = 'real' or nme = 'double' then return cast(i * 0.12 as
bigint); end if ; return 0; end;
-create system function internaltransform(geom geometry, srid_src integer,
srid_dest integer, proj4_src string, proj4_dest string) returns geometry
external name geom."Transform";
-create system function isaurl(theurl url) returns bool external name
url."isaURL";
-create system function sys.isauuid(s string) returns boolean external name
uuid."isaUUID";
-create system function "left_shift"(i1 inet, i2 inet) returns boolean external
name inet."<<";
-create system function "left_shift_assign"(i1 inet, i2 inet) returns boolean
external name inet."<<=";
-create system procedure lidarattach(fname string) external name lidar.attach;
-create system procedure lidarexport(tname string, fname string, format string)
external name lidar.export;
-create system procedure lidarload(tname string) external name lidar.load;
-create system filter function "like"(val string, pat string) external name
algebra."like";
-create system filter function "like"(val string, pat string, esc string)
external name algebra."like";
-create system procedure listdir(dirname string) external name fits.listdir;
-create system procedure listdirpat(dirname string,pat string) external name
fits.listdirpattern;
-create system function sys.malfunctions() returns table("module" string,
"function" string, "signature" string, "address" string, "comment" string)
external name "manual"."functions";
-create system function "masklen" (p inet) returns int external name
inet."masklen";
-create system procedure master() external name wlc.master;
-create system procedure master(path string) external name wlc.master;
-create system procedure masterbeat(duration int) external name
wlc."setmasterbeat";
-create system function masterclock() returns string external name
wlc."getmasterclock";
-create system function mastertick() returns bigint external name
wlc."getmastertick";
-create system function mbr(geom geometry) returns mbr external name geom."mbr";
-create system function sys.md5(v string) returns string external name
clients.md5sum;
-create system aggregate median(val bigint) returns bigint external name
"aggr"."median";
-create system aggregate median(val date) returns date external name
"aggr"."median";
-create system aggregate median(val decimal) returns decimal external name
"aggr"."median";
-create system aggregate median(val double) returns double external name
"aggr"."median";
-create system aggregate median(val integer) returns integer external name
"aggr"."median";
-create system aggregate median(val real) returns real external name
"aggr"."median";
-create system aggregate median(val smallint) returns smallint external name
"aggr"."median";
-create system aggregate median(val time) returns time external name
"aggr"."median";
-create system aggregate median(val timestamp) returns timestamp external name
"aggr"."median";
-create system aggregate median(val tinyint) returns tinyint external name
"aggr"."median";
-create system function ms_round(num double, prc int, truncat int) returns
double begin if (truncat = 0) then return round(num, prc); else return
ms_trunc(num, prc); end if; end;
-create system function ms_str(num float, prc int, truncat int) returns string
begin return cast(num as string); end;
-create system function ms_stuff(s1 varchar(32), st int, len int, s3
varchar(32)) returns varchar(32) begin declare res varchar(32), aux
varchar(32); declare ofset int; if (st < 0 or st > length(s1)) then return '';
end if; set ofset = 1; set res = substring(s1,ofset,st-1); set res = res || s3;
set ofset = st + len; set aux = substring(s1,ofset,length(s1)-ofset+1); set res
= res || aux; return res; end;
-create system function ms_trunc(num double, prc int) returns double external
name sql.ms_trunc;
-create system procedure netcdf_attach(fname varchar(256)) external name
netcdf.attach;
-create system procedure netcdf_importvar(fid integer, varnname varchar(256))
external name netcdf.importvariable;
-create system function "netmask" (p inet) returns inet external name
inet."netmask";
-create system function "network" (p inet) returns inet external name
inet."network";
-create system function newurl(protocol string, hostname string, "port" int,
file string) returns url external name url."new";
-create system function newurl(protocol string, hostname string, file string)
returns url external name url."new";
-create system function sys.optimizer_stats() returns table (optname string,
count int, timing bigint) external name inspect.optimizer_stats;
-create system function sys.optimizers () returns table (name string, def
string, status string) external name sql.optimizers;
-create system function sys.password_hash (username string) returns string
external name sql.password;
-create system procedure sys.pause(tag bigint) external name sql.sysmon_pause;
-create system procedure sys.pause(tag int) external name sql.sysmon_pause;
-create system aggregate quantile(val bigint, q double) returns bigint external
name "aggr"."quantile";
-create system aggregate quantile(val date, q double) returns date external
name "aggr"."quantile";
-create system aggregate quantile(val decimal, q double) returns decimal
external name "aggr"."quantile";
-create system aggregate quantile(val double, q double) returns double external
name "aggr"."quantile";
-create system aggregate quantile(val integer, q double) returns integer
external name "aggr"."quantile";
-create system aggregate quantile(val real, q double) returns real external
name "aggr"."quantile";
-create system aggregate quantile(val smallint, q double) returns smallint
external name "aggr"."quantile";
-create system aggregate quantile(val time, q double) returns time external
name "aggr"."quantile";
-create system aggregate quantile(val timestamp, q double) returns timestamp
external name "aggr"."quantile";
-create system aggregate quantile(val tinyint, q double) returns tinyint
external name "aggr"."quantile";
-create system function sys.querycache() returns table (query string, count
int) external name sql.dump_cache;
-create system procedure sys.querylog(filename string) external name
sql.logfile;
-create system function sys.querylog_calls() returns table(id oid, "start"
timestamp, "stop" timestamp, arguments string, tuples bigint, run bigint, ship
bigint, cpu int, io int) external name sql.querylog_calls;
-create system function sys.querylog_catalog() returns table(id oid, owner
string, defined timestamp, query string, pipe string, "plan" string, mal int,
optimize bigint) external name sql.querylog_catalog;
-create system procedure sys.querylog_disable() external name
sql.querylog_disable;
-create system procedure sys.querylog_empty() external name sql.querylog_empty;
-create system procedure sys.querylog_enable() external name
sql.querylog_enable;
-create system procedure sys.querylog_enable(threshold smallint) external name
sql.querylog_enable_threshold;
-create system function sys.queue() returns table(qtag bigint, "user" string,
started timestamp, estimate timestamp, progress int, status string, tag oid,
query string) external name sql.sysmon_queue;
-create system function radians(d double) returns double return d*pi()/180;
-create system function sys.rejects() returns table(rowid bigint, fldid int,
"message" string, "input" string) external name sql.copy_rejects;
-create system procedure replicabeat(duration integer) external name
wlr."setreplicabeat";
-create system function replicaclock() returns string external name
wlr."getreplicaclock";
-create system procedure replicate() external name wlr.replicate;
-create system procedure replicate(dbname string) external name wlr.replicate;
-create system procedure replicate(dbname string, id bigint) external name
wlr.replicate;
-create system procedure replicate(dbname string, id integer) external name
wlr.replicate;
-create system procedure replicate(dbname string, id smallint) external name
wlr.replicate;
-create system procedure replicate(dbname string, id tinyint) external name
wlr.replicate;
-create system procedure replicate(dbname string, pointintime timestamp)
external name wlr.replicate;
-create system procedure replicate(pointintime timestamp) external name
wlr.replicate;
-create system function replicatick() returns bigint external name
wlr."getreplicatick";
-create system procedure sys.resume(tag bigint) external name sql.sysmon_resume;
-create system procedure sys.resume(tag int) external name sql.sysmon_resume;
-create system procedure reuse(sys string, tab string) external name sql.reuse;
-create system function reverse(src string) returns string external name
udf.reverse;
-create system function "right_shift"(i1 inet, i2 inet) returns boolean
external name inet.">>";
-create system function "right_shift_assign"(i1 inet, i2 inet) returns boolean
external name inet.">>=";
-create system function sys.sessions() returns table("user" string, "login"
timestamp, "sessiontimeout" bigint, "lastcommand" timestamp, "querytimeout"
bigint, "active" bool) external name sql.sessions;
-create system function "setmasklen" (p inet, mask int) returns inet external
name inet."setmasklen";
-create system procedure sys.setsession("timeout" bigint) external name
clients.setsession;
-create system procedure sys.settimeout("query" bigint) external name
clients.settimeout;
-create system procedure sys.settimeout("query" bigint, "session" bigint)
external name clients.settimeout;
-create system procedure shpattach(fname string) external name shp.attach;
-create system procedure shpload(fid integer) external name shp.import;
-create system procedure shpload(fid integer, filter geometry) external name
shp.import;
-create system procedure shrink(sys string, tab string) external name
sql.shrink;
-create system procedure sys.shutdown(delay tinyint) external name sql.shutdown;
-create system procedure sys.shutdown(delay tinyint, force bool) external name
sql.shutdown;
-create system function st_area(geom geometry) returns double external name
geom."Area";
-create system function st_asbinary(geom geometry) returns string external name
geom."AsBinary";
-create system function st_asewkt(geom geometry) returns string external name
geom."AsEWKT";
-create system function st_astext(geom geometry) returns string external name
geom."AsText";
-create system function st_bdmpolyfromtext(wkt string, srid integer) returns
geometry external name geom."BdMPolyFromText";
-create system function st_bdpolyfromtext(wkt string, srid integer) returns
geometry external name geom."BdPolyFromText";
-create system function st_boundary(geom geometry) returns geometry external
name geom."Boundary";
-create system function st_buffer(geom geometry, radius double) returns
geometry external name geom."Buffer";
-create system function st_centroid(geom geometry) returns geometry external
name geom."Centroid";
-create system aggregate st_collect(geom geometry) returns geometry external
name geom."Union";
-create system function st_collect(geom1 geometry, geom2 geometry) returns
geometry external name geom."Union";
-create system function st_contains(box1 mbr, box2 mbr) returns boolean
external name geom."mbrContains";
-create system function st_contains(geom1 geometry, geom2 geometry) returns
boolean external name geom."Contains";
-create system function st_convexhull(geom geometry) returns geometry external
name geom."ConvexHull";
-create system function st_coorddim(geom geometry) returns integer external
name geom."CoordDim";
-create system function st_coveredby(geom1 geometry, geom2 geometry) returns
boolean external name geom."CoveredBy";
-create system function st_covers(geom1 geometry, geom2 geometry) returns
boolean external name geom."Covers";
-create system function st_crosses(geom1 geometry, geom2 geometry) returns
boolean external name geom."Crosses";
-create system function st_delaunaytriangles(geom geometry, tolerance double,
flags integer) returns geometry external name geom."DelaunayTriangles";
-create system function st_difference(geom1 geometry, geom2 geometry) returns
geometry external name geom."Difference";
-create system function st_dimension(geom geometry) returns integer external
name geom."Dimension";
-create system function st_disjoint(geom1 geometry, geom2 geometry) returns
boolean external name geom."Disjoint";
-create system function st_distance(box1 mbr, box2 mbr) returns double external
name geom."mbrDistance";
-create system function st_distance(geom1 geometry, geom2 geometry) returns
double external name geom."Distance";
-create system function st_dump(geom geometry) returns table(id string,
polygonwkb geometry) external name geom."Dump";
-create system function st_dumppoints(geom geometry) returns table(path string,
pointg geometry) external name geom."DumpPoints";
-create system function st_dwithin(geom1 geometry, geom2 geometry, dst double)
returns boolean external name geom."DWithin";
-create system function st_endpoint(geom geometry) returns geometry external
name geom."EndPoint";
-create system function st_envelope(geom geometry) returns geometry external
name geom."Envelope";
-create system function st_equals(box1 mbr, box2 mbr) returns boolean external
name geom."mbrEqual";
-create system function st_equals(geom1 geometry, geom2 geometry) returns
boolean external name geom."Equals";
-create system function st_exteriorring(geom geometry) returns geometry
external name geom."ExteriorRing";
-create system function st_force2d(geom geometry) returns geometry external
name geom."Force2D";
-create system function st_force3d(geom geometry) returns geometry external
name geom."Force3D";
-create system function st_geomcollfromtext(wkt string) returns geometry
external name geom."GeomCollFromText";
-create system function st_geomcollfromtext(wkt string, srid integer) returns
geometry external name geom."GeomCollFromText";
-create system function st_geometryfromtext(wkt string) returns geometry
external name geom."GeomFromText";
-create system function st_geometryfromtext(wkt string, srid integer) returns
geometry external name geom."GeomFromText";
-create system function st_geometryn(geom geometry, positionnum integer)
returns geometry external name geom."GeometryN";
-create system function st_geometrytype(geom geometry) returns string external
name geom."GeometryType2";
-create system function st_geomfromtext(wkt string) returns geometry external
name geom."GeomFromText";
-create system function st_geomfromtext(wkt string, srid integer) returns
geometry external name geom."GeomFromText";
-create system function st_interiorringn(geom geometry, positionnum integer)
returns geometry external name geom."InteriorRingN";
-create system function st_interiorrings(geom geometry) returns geometrya
external name geom."InteriorRings";
-create system function st_intersection(geom1 geometry, geom2 geometry) returns
geometry external name geom."Intersection";
-create system function st_intersects(geom1 geometry, geom2 geometry) returns
boolean external name geom."Intersects";
-create system function st_isclosed(geom geometry) returns boolean external
name geom."IsClosed";
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
