Changeset: 69e2191d7288 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=69e2191d7288
Modified Files:
sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/check.stable.out
sql/test/emptydb-upgrade-chain/Tests/check.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128
sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128
sql/test/emptydb-upgrade/Tests/check.stable.out
sql/test/emptydb-upgrade/Tests/check.stable.out.32bit
sql/test/emptydb-upgrade/Tests/check.stable.out.int128
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: Jul2017
Log Message:
Combined args and functions check test into a single query.
Now we have one row in one table per function instead of one row each
in two tables.
diffs (truncated from 54136 to 300 lines):
diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128
@@ -1190,8 +1190,6 @@ select name, authorization, owner, syste
select s.name, t.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(t.query, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
t.type, t.system, t.commit_action, t.access from sys._tables t left outer join
sys.schemas s on t.schema_id = s.id order by s.name, t.name;
-- _columns
select t.name, c.name, c.type, c.type_digits, c.type_scale, c."default",
c."null", c.number, c.storage from sys._tables t, sys._columns c where t.id =
c.table_id order by t.name, c.number;
--- functions
-select s.name, f.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
f.mod, f.language, f.type, f.side_effect, f.varres, f.vararg from sys.functions
f left outer join sys.schemas s on f.schema_id = s.id order by s.name, f.name,
query;
-- external functions that don't reference existing MAL function (should be
empty)
with x(name,func) as (select name, splitpart(func, ' external name ', 2) from
sys.functions where func like '% external name %' union select name,
splitpart(func, ' EXTERNAL NAME ', 2) from sys.functions where func like '%
EXTERNAL NAME %'), y(name,func) as (select name, trim(splitpart(func, ';', 1))
from x), z(name, mod, func) as (select name, trim(splitpart(func, '.', 1),
'"'), trim(splitpart(func, '.', 2), '"') from y) select z.name, z.mod, z.func
from z where z.mod || '.' || z.func not in (select m.module || '.' ||
m."function" from sys.malfunctions() m);
-- args
@@ -1211,8 +1209,9 @@ arg12 (id, id1, name1, type1, type_digit
arg13 (id, id1, name1, type1, type_digits1, type_scale1, inout1, id2, name2,
type2, type_digits2, type_scale2, inout2, id3, name3, type3, type_digits3,
type_scale3, inout3, id4, name4, type4, type_digits4, type_scale4, inout4, id5,
name5, type5, type_digits5, type_scale5, inout5, id6, name6, type6,
type_digits6, type_scale6, inout6, id7, name7, type7, type_digits7,
type_scale7, inout7, id8, name8, type8, type_digits8, type_scale8, inout8, id9,
name9, type9, type_digits9, type_scale9, inout9, id10, name10, type10,
type_digits10, type_scale10, inout10, id11, name11, type11, type_digits11,
type_scale11, inout11, id12, name12, type12, type_digits12, type_scale12,
inout12, id13, name13, type13, type_digits13, type_scale13, inout13) as (select
arg12.*, a13.id, a13.name, a13.type, a13.type_digits, a13.type_scale, a13.inout
from arg12 left outer join args a13 on a13.func_id = arg12.id and a13.number =
13),
arg14 (id, id1, name1, type1, type_digits1, type_scale1, inout1, id2, name2,
type2, type_digits2, type_scale2, inout2, id3, name3, type3, type_digits3,
type_scale3, inout3, id4, name4, type4, type_digits4, type_scale4, inout4, id5,
name5, type5, type_digits5, type_scale5, inout5, id6, name6, type6,
type_digits6, type_scale6, inout6, id7, name7, type7, type_digits7,
type_scale7, inout7, id8, name8, type8, type_digits8, type_scale8, inout8, id9,
name9, type9, type_digits9, type_scale9, inout9, id10, name10, type10,
type_digits10, type_scale10, inout10, id11, name11, type11, type_digits11,
type_scale11, inout11, id12, name12, type12, type_digits12, type_scale12,
inout12, id13, name13, type13, type_digits13, type_scale13, inout13, id14,
name14, type14, type_digits14, type_scale14, inout14) as (select arg13.*,
a14.id, a14.name, a14.type, a14.type_digits, a14.type_scale, a14.inout from
arg13 left outer join args a14 on a14.func_id = arg13.id and a14.number = 14),
arg15 (id, id1, name1, type1, type_digits1, type_scale1, inout1, id2, name2,
type2, type_digits2, type_scale2, inout2, id3, name3, type3, type_digits3,
type_scale3, inout3, id4, name4, type4, type_digits4, type_scale4, inout4, id5,
name5, type5, type_digits5, type_scale5, inout5, id6, name6, type6,
type_digits6, type_scale6, inout6, id7, name7, type7, type_digits7,
type_scale7, inout7, id8, name8, type8, type_digits8, type_scale8, inout8, id9,
name9, type9, type_digits9, type_scale9, inout9, id10, name10, type10,
type_digits10, type_scale10, inout10, id11, name11, type11, type_digits11,
type_scale11, inout11, id12, name12, type12, type_digits12, type_scale12,
inout12, id13, name13, type13, type_digits13, type_scale13, inout13, id14,
name14, type14, type_digits14, type_scale14, inout14, id15, name15, type15,
type_digits15, type_scale15, inout15) as (select arg14.*, a15.id, a15.name,
a15.type, a15.type_digits, a15.type_scale, a15.inout from arg14 left outer join
args a15 on a15.func_i
d = arg14.id and a15.number = 15),
-arg16 (id, id1, name1, type1, type_digits1, type_scale1, inout1, id2, name2,
type2, type_digits2, type_scale2, inout2, id3, name3, type3, type_digits3,
type_scale3, inout3, id4, name4, type4, type_digits4, type_scale4, inout4, id5,
name5, type5, type_digits5, type_scale5, inout5, id6, name6, type6,
type_digits6, type_scale6, inout6, id7, name7, type7, type_digits7,
type_scale7, inout7, id8, name8, type8, type_digits8, type_scale8, inout8, id9,
name9, type9, type_digits9, type_scale9, inout9, id10, name10, type10,
type_digits10, type_scale10, inout10, id11, name11, type11, type_digits11,
type_scale11, inout11, id12, name12, type12, type_digits12, type_scale12,
inout12, id13, name13, type13, type_digits13, type_scale13, inout13, id14,
name14, type14, type_digits14, type_scale14, inout14, id15, name15, type15,
type_digits15, type_scale15, inout15, id16, name16, type16, type_digits16,
type_scale16, inout16) as (select arg15.*, a16.id, a16.name, a16.type,
a16.type_digits, a16.type_scale,
a16.inout from arg15 left outer join args a16 on a16.func_id = arg15.id and
a16.number = 16)
-select s.name, f.name, arg16.name1, arg16.type1, arg16.type_digits1,
arg16.type_scale1, arg16.inout1, arg16.name2, arg16.type2, arg16.type_digits2,
arg16.type_scale2, arg16.inout2, arg16.name3, arg16.type3, arg16.type_digits3,
arg16.type_scale3, arg16.inout3, arg16.name4, arg16.type4, arg16.type_digits4,
arg16.type_scale4, arg16.inout4, arg16.name5, arg16.type5, arg16.type_digits5,
arg16.type_scale5, arg16.inout5, arg16.name6, arg16.type6, arg16.type_digits6,
arg16.type_scale6, arg16.inout6, arg16.name7, arg16.type7, arg16.type_digits7,
arg16.type_scale7, arg16.inout7, arg16.name8, arg16.type8, arg16.type_digits8,
arg16.type_scale8, arg16.inout8, arg16.name9, arg16.type9, arg16.type_digits9,
arg16.type_scale9, arg16.inout9, arg16.name10, arg16.type10,
arg16.type_digits10, arg16.type_scale10, arg16.inout10, arg16.name11,
arg16.type11, arg16.type_digits11, arg16.type_scale11, arg16.inout11,
arg16.name12, arg16.type12, arg16.type_digits12, arg16.type_scale12,
arg16.inout12, arg16.name1
3, arg16.type13, arg16.type_digits13, arg16.type_scale13, arg16.inout13,
arg16.name14, arg16.type14, arg16.type_digits14, arg16.type_scale14,
arg16.inout14, arg16.name15, arg16.type15, arg16.type_digits15,
arg16.type_scale15, arg16.inout15 from arg16, sys.schemas s, sys.functions f
where s.id = f.schema_id and f.id = arg16.id order by s.name, f.name,
arg16.name1, arg16.type1, arg16.type_digits1, arg16.type_scale1, arg16.inout1,
arg16.name2, arg16.type2, arg16.type_digits2, arg16.type_scale2, arg16.inout2,
arg16.name3, arg16.type3, arg16.type_digits3, arg16.type_scale3, arg16.inout3,
arg16.name4, arg16.type4, arg16.type_digits4, arg16.type_scale4, arg16.inout4,
arg16.name5, arg16.type5, arg16.type_digits5, arg16.type_scale5, arg16.inout5,
arg16.name6, arg16.type6, arg16.type_digits6, arg16.type_scale6, arg16.inout6,
arg16.name7, arg16.type7, arg16.type_digits7, arg16.type_scale7, arg16.inout7,
arg16.name8, arg16.type8, arg16.type_digits8, arg16.type_scale8, arg16.inout8,
arg16.name9,
arg16.type9, arg16.type_digits9, arg16.type_scale9, arg16.inout9,
arg16.name10, arg16.type10, arg16.type_digits10, arg16.type_scale10,
arg16.inout10, arg16.name11, arg16.type11, arg16.type_digits11,
arg16.type_scale11, arg16.inout11, arg16.name12, arg16.type12,
arg16.type_digits12, arg16.type_scale12, arg16.inout12, arg16.name13,
arg16.type13, arg16.type_digits13, arg16.type_scale13, arg16.inout13,
arg16.name14, arg16.type14, arg16.type_digits14, arg16.type_scale14,
arg16.inout14, arg16.name15, arg16.type15, arg16.type_digits15,
arg16.type_scale15, arg16.inout15;
+arg16 (id, id1, name1, type1, type_digits1, type_scale1, inout1, id2, name2,
type2, type_digits2, type_scale2, inout2, id3, name3, type3, type_digits3,
type_scale3, inout3, id4, name4, type4, type_digits4, type_scale4, inout4, id5,
name5, type5, type_digits5, type_scale5, inout5, id6, name6, type6,
type_digits6, type_scale6, inout6, id7, name7, type7, type_digits7,
type_scale7, inout7, id8, name8, type8, type_digits8, type_scale8, inout8, id9,
name9, type9, type_digits9, type_scale9, inout9, id10, name10, type10,
type_digits10, type_scale10, inout10, id11, name11, type11, type_digits11,
type_scale11, inout11, id12, name12, type12, type_digits12, type_scale12,
inout12, id13, name13, type13, type_digits13, type_scale13, inout13, id14,
name14, type14, type_digits14, type_scale14, inout14, id15, name15, type15,
type_digits15, type_scale15, inout15, id16, name16, type16, type_digits16,
type_scale16, inout16) as (select arg15.*, a16.id, a16.name, a16.type,
a16.type_digits, a16.type_scale,
a16.inout from arg15 left outer join args a16 on a16.func_id = arg15.id and
a16.number = 16),
+funcs as (select f.id, f.name, f.func, f.mod, f.language, ft.type,
f.side_effect, f.varres, f.vararg, f.schema_id from sys.functions f left outer
join (values ('function',1),('procedure',2),('aggregate',3),('filter
function',4),('table function',5),('analytic function',6),('loader
function',7)) as ft (type,id) on f.type = ft.id)
+select s.name, funcs.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(funcs.func, '--.*\n',
'', ''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
funcs.mod, funcs.language, funcs.type, funcs.side_effect, funcs.varres,
funcs.vararg, arg16.name1, arg16.type1, arg16.type_digits1, arg16.type_scale1,
arg16.inout1, arg16.name2, arg16.type2, arg16.type_digits2, arg16.type_scale2,
arg16.inout2, arg16.name3, arg16.type3, arg16.type_digits3, arg16.type_scale3,
arg16.inout3, arg16.name4, arg16.type4, arg16.type_digits4, arg16.type_scale4,
arg16.inout4, arg16.name5, arg16.type5, arg16.type_digits5, arg16.type_scale5,
arg16.inout5, arg16.name6, arg16.type6, arg16.type_digits6, arg16.type_scale6,
arg16.inout6, arg16.name7, arg16.type7, arg16.type_digits7, arg16.type_scale7,
arg16.inout7, arg16.name8, arg16.type8, arg16.type_digits8, arg16.type_scale8,
arg16.inout8, arg16.name9, arg16.type9, arg16.type_digits9, arg16.type_scale9,
arg16.inout9, arg16.name10, ar
g16.type10, arg16.type_digits10, arg16.type_scale10, arg16.inout10,
arg16.name11, arg16.type11, arg16.type_digits11, arg16.type_scale11,
arg16.inout11, arg16.name12, arg16.type12, arg16.type_digits12,
arg16.type_scale12, arg16.inout12, arg16.name13, arg16.type13,
arg16.type_digits13, arg16.type_scale13, arg16.inout13, arg16.name14,
arg16.type14, arg16.type_digits14, arg16.type_scale14, arg16.inout14,
arg16.name15, arg16.type15, arg16.type_digits15, arg16.type_scale15,
arg16.inout15 from arg16, sys.schemas s, funcs where s.id = funcs.schema_id and
funcs.id = arg16.id order by s.name, funcs.name, arg16.name1, arg16.type1,
arg16.type_digits1, arg16.type_scale1, arg16.inout1, arg16.name2, arg16.type2,
arg16.type_digits2, arg16.type_scale2, arg16.inout2, arg16.name3, arg16.type3,
arg16.type_digits3, arg16.type_scale3, arg16.inout3, arg16.name4, arg16.type4,
arg16.type_digits4, arg16.type_scale4, arg16.inout4, arg16.name5, arg16.type5,
arg16.type_digits5, arg16.type_scale5, arg16.inout5,
arg16.name6, arg16.type6, arg16.type_digits6, arg16.type_scale6, arg16.inout6,
arg16.name7, arg16.type7, arg16.type_digits7, arg16.type_scale7, arg16.inout7,
arg16.name8, arg16.type8, arg16.type_digits8, arg16.type_scale8, arg16.inout8,
arg16.name9, arg16.type9, arg16.type_digits9, arg16.type_scale9, arg16.inout9,
arg16.name10, arg16.type10, arg16.type_digits10, arg16.type_scale10,
arg16.inout10, arg16.name11, arg16.type11, arg16.type_digits11,
arg16.type_scale11, arg16.inout11, arg16.name12, arg16.type12,
arg16.type_digits12, arg16.type_scale12, arg16.inout12, arg16.name13,
arg16.type13, arg16.type_digits13, arg16.type_scale13, arg16.inout13,
arg16.name14, arg16.type14, arg16.type_digits14, arg16.type_scale14,
arg16.inout14, arg16.name15, arg16.type15, arg16.type_digits15,
arg16.type_scale15, arg16.inout15;
-- auths
select name, grantor from sys.auths;
-- db_user_info
@@ -1730,1731 +1729,6 @@ drop function pcre_replace(string, strin
[ "users", "name", "varchar", 1024, 0, NULL, true, 0,
NULL ]
[ "users", "fullname", "varchar", 2024, 0, NULL, true,
1, NULL ]
[ "users", "default_schema", "int", 9, 0, NULL, true,
2, NULL ]
-#select s.name, f.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
f.mod, f.language, f.type, f.side_effect, f.varres, f.vararg from sys.functions
f left outer join sys.schemas s on f.schema_id = s.id order by s.name, f.name,
query;
-% .s, .f, .L4, .f, .f, .f, .f, .f, .f # table_name
-% name, name, query, mod, language, type, side_effect,
varres, vararg # name
-% varchar, varchar, varchar, varchar, int, int,
boolean, boolean, boolean # type
-% 8, 35, 831, 9, 1, 1, 5, 5, 5 # length
-[ "bam", "bam_drop_file", "create procedure
bam.bam_drop_file(file_id bigint, dbschema smallint) external name
bam.bam_drop_file;", "bam", 1, 2, true, false, false ]
-[ "bam", "bam_export", "create procedure bam.bam_export(output_path
string) external name bam.bam_export;", "bam", 1, 2, true,
false, false ]
-[ "bam", "bam_flag", "create function bam.bam_flag(flag smallint,
name string) returns boolean external name bam.bam_flag;", "bam", 1, 1,
false, false, false ]
-[ "bam", "bam_loader_file", "create procedure
bam.bam_loader_file(bam_file string, dbschema smallint) external name
bam.bam_loader_file;", "bam", 1, 2, true, false, false ]
-[ "bam", "bam_loader_files", "create procedure
bam.bam_loader_files(bam_files string, dbschema smallint) external name
bam.bam_loader_files;", "bam", 1, 2, true, false, false ]
-[ "bam", "bam_loader_repos", "create procedure
bam.bam_loader_repos(bam_repos string, dbschema smallint) external name
bam.bam_loader_repos;", "bam", 1, 2, true, false, false ]
-[ "bam", "reverse_qual", "create function bam.reverse_qual(qual string)
returns string external name bam.reverse_qual;", "bam", 1, 1, false,
false, false ]
-[ "bam", "reverse_seq", "create function bam.reverse_seq(seq string)
returns string external name bam.reverse_seq;", "bam", 1, 1,
false, false, false ]
-[ "bam", "sam_export", "create procedure bam.sam_export(output_path
string) external name bam.sam_export;", "bam", 1, 2, true,
false, false ]
-[ "bam", "seq_char", "create function bam.seq_char(ref_pos int,
alg_seq string, alg_pos int, alg_cigar string) returns char(1) external name
bam.seq_char;", "bam", 1, 1, false, false, false ]
-[ "bam", "seq_length", "create function bam.seq_length(cigar string)
returns int external name bam.seq_length;", "bam", 1, 1,
false, false, false ]
-[ "json", "filter", "create function json.filter(js json, name
bigint) returns json external name json.filter;", "json", 1, 1,
false, false, false ]
-[ "json", "filter", "create function json.filter(js json, name
hugeint) returns json external name json.filter;", "json", 1, 1,
false, false, false ]
-[ "json", "filter", "create function json.filter(js json, name
integer) returns json external name json.filter;", "json", 1, 1,
false, false, false ]
-[ "json", "filter", "create function json.filter(js json, name
tinyint) returns json external name json.filter;", "json", 1, 1,
false, false, false ]
-[ "json", "filter", "create function json.filter(js json, pathexpr
string) returns json external name json.filter;", "json", 1, 1,
false, false, false ]
-[ "json", "integer", "create function json.\"integer\"(js json)
returns bigint external name json.\"integer\";", "json", 1, 1,
false, false, false ]
-[ "json", "isarray", "create function json.isarray(js json) returns
bool external name json.isarray;", "json", 1, 1, false, false,
false ]
-[ "json", "isarray", "create function json.isarray(js string)
returns bool external name json.isarray;", "json", 1, 1, false,
false, false ]
-[ "json", "isobject", "create function json.isobject(js json) returns
bool external name json.isobject;", "json", 1, 1, false, false,
false ]
-[ "json", "isobject", "create function json.isobject(js string)
returns bool external name json.isobject;", "json", 1, 1, false,
false, false ]
-[ "json", "isvalid", "create function json.isvalid(js json) returns
bool external name json.isvalid;", "json", 1, 1, false, false,
false ]
-[ "json", "isvalid", "create function json.isvalid(js string)
returns bool external name json.isvalid;", "json", 1, 1, false,
false, false ]
-[ "json", "keyarray", "create function json.keyarray(js json) returns
json external name json.keyarray;", "json", 1, 1, false, false,
false ]
-[ "json", "length", "create function json.length(js json) returns
integer external name json.length;", "json", 1, 1, false,
false, false ]
-[ "json", "number", "create function json.number(js json) returns
float external name json.number;", "json", 1, 1, false,
false, false ]
-[ "json", "output", "create aggregate json.output(js json) returns
string external name json.output;", "json", 1, 3, false, false,
false ]
-[ "json", "text", "create function json.text(js int) returns string
external name json.text;", "json", 1, 1, false, false, false ]
-[ "json", "text", "create function json.text(js json) returns string
external name json.text;", "json", 1, 1, false, false, false ]
-[ "json", "text", "create function json.text(js json, e string) returns
string external name json.text;", "json", 1, 1, false, false, false
]
-[ "json", "text", "create function json.text(js string) returns string
external name json.text;", "json", 1, 1, false, false, false ]
-[ "json", "tojsonarray", "create aggregate json.tojsonarray(x double)
returns string external name aggr.jsonaggr;", "aggr", 1, 3,
false, false, false ]
-[ "json", "tojsonarray", "create aggregate json.tojsonarray(x string)
returns string external name aggr.jsonaggr;", "aggr", 1, 3,
false, false, false ]
-[ "json", "valuearray", "create function json.valuearray(js json)
returns json external name json.valuearray;", "json", 1, 1, false,
false, false ]
-[ "profiler", "getlimit", "create function profiler.getlimit() returns
integer external name profiler.getlimit;", "profiler", 1, 1,
false, false, false ]
-[ "profiler", "setheartbeat", "create procedure profiler.setheartbeat(beat
int) external name profiler.setheartbeat;", "profiler", 1, 2,
true, false, false ]
-[ "profiler", "setlimit", "create procedure profiler.setlimit(lim
integer) external name profiler.setlimit;", "profiler", 1, 2,
true, false, false ]
-[ "profiler", "start", "create procedure profiler.start() external
name profiler.\"start\";", "profiler", 1, 2, true, false,
false ]
-[ "profiler", "stop", "create procedure profiler.stop() external name
profiler.stop;", "profiler", 1, 2, true, false, false
]
-[ "sys", "<", "<", "calc", 0, 1, false, false, false
]
-[ "sys", "<=", "<=", "calc", 0, 1, false, false, false
]
-[ "sys", "<>", "!=", "calc", 0, 1, false, false, false
]
-[ "sys", "=", "=", "calc", 0, 1, false, false, false
]
-[ "sys", ">", ">", "calc", 0, 1, false, false, false
]
-[ "sys", ">=", ">=", "calc", 0, 1, false, false, false
]
-[ "sys", "abbrev", "create function \"abbrev\" (p inet) returns
clob external name inet.\"abbrev\";", "inet", 1, 1, false,
false, false ]
-[ "sys", "abs", "abs", "calc", 0, 1, false, false, false
]
-[ "sys", "abs", "abs", "calc", 0, 1, false, false, false
]
-[ "sys", "abs", "abs", "calc", 0, 1, false, false, false
]
-[ "sys", "abs", "abs", "calc", 0, 1, false, false, false
]
-[ "sys", "abs", "abs", "calc", 0, 1, false, false, false
]
-[ "sys", "abs", "abs", "calc", 0, 1, false, false, false
]
-[ "sys", "abs", "abs", "calc", 0, 1, false, false, false
]
-[ "sys", "abs", "abs", "calc", 0, 1, false, false, false
]
-[ "sys", "abs", "abs", "calc", 0, 1, false, false, false
]
-[ "sys", "abs", "abs", "calc", 0, 1, false, false, false
]
-[ "sys", "abs", "abs", "calc", 0, 1, false, false, false
]
-[ "sys", "abs", "abs", "calc", 0, 1, false, false, false
]
-[ "sys", "abs", "abs", "calc", 0, 1, false, false, false
]
-[ "sys", "abs", "abs", "calc", 0, 1, false, false, false
]
-[ "sys", "abs", "abs", "calc", 0, 1, false, false, false
]
-[ "sys", "acos", "acos", "mmath", 0, 1, false, false,
false ]
-[ "sys", "acos", "acos", "mmath", 0, 1, false, false,
false ]
-[ "sys", "all", "all", "sql", 0, 3, false, false, false
]
-[ "sys", "alpha", "create function alpha(pdec double, pradius
double) returns double external name sql.alpha;", "sql", 1, 1,
false, false, false ]
-[ "sys", "analyze", "create procedure sys.analyze(minmax int,
\"sample\" bigint) external name sql.analyze;", "sql", 1, 2,
true, false, false ]
-[ "sys", "analyze", "create procedure sys.analyze(minmax int,
\"sample\" bigint, sch string) external name sql.analyze;", "sql", 1,
2, true, false, false ]
-[ "sys", "analyze", "create procedure sys.analyze(minmax int,
\"sample\" bigint, sch string, tbl string) external name sql.analyze;",
"sql", 1, 2, true, false, false ]
-[ "sys", "analyze", "create procedure sys.analyze(minmax int,
\"sample\" bigint, sch string, tbl string, col string) external name
sql.analyze;", "sql", 1, 2, true, false, false ]
-[ "sys", "and", "and", "calc", 0, 1, false, false, false
]
-[ "sys", "ascii", "ascii", "str", 0, 1, false,
false, false ]
-[ "sys", "ascii", "ascii", "str", 0, 1, false,
false, false ]
-[ "sys", "ascii", "ascii", "str", 0, 1, false,
false, false ]
-[ "sys", "asin", "asin", "mmath", 0, 1, false, false,
false ]
-[ "sys", "asin", "asin", "mmath", 0, 1, false, false,
false ]
-[ "sys", "atan", "atan", "mmath", 0, 1, false, false,
false ]
-[ "sys", "atan", "atan", "mmath", 0, 1, false, false,
false ]
-[ "sys", "atan", "atan2", "mmath", 0, 1, false,
false, false ]
-[ "sys", "atan", "atan2", "mmath", 0, 1, false,
false, false ]
-[ "sys", "avg", "avg", "aggr", 0, 3, false, false, false
]
-[ "sys", "avg", "avg", "aggr", 0, 3, false, false, false
]
-[ "sys", "avg", "avg", "aggr", 0, 3, false, false, false
]
-[ "sys", "avg", "avg", "aggr", 0, 3, false, false, false
]
-[ "sys", "avg", "avg", "aggr", 0, 3, false, false, false
]
-[ "sys", "avg", "avg", "aggr", 0, 3, false, false, false
]
-[ "sys", "avg", "avg", "aggr", 0, 3, false, false, false
]
-[ "sys", "bbp", "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", 1, 5, false, false, false ]
-[ "sys", "bit_and", "and", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_and", "and", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_and", "and", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_and", "and", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_and", "and", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_and", "and", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_and", "and", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_and", "and", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_and", "and", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_and", "and", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_and", "and", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_not", "not", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_not", "not", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_not", "not", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_not", "not", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_not", "not", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_not", "not", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_not", "not", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_not", "not", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_not", "not", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_not", "not", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_not", "not", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_or", "or", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_or", "or", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_or", "or", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_or", "or", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_or", "or", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_or", "or", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_or", "or", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_or", "or", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_or", "or", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_or", "or", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_or", "or", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_xor", "xor", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_xor", "xor", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_xor", "xor", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_xor", "xor", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_xor", "xor", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_xor", "xor", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_xor", "xor", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_xor", "xor", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_xor", "xor", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_xor", "xor", "calc", 0, 1, false, false,
false ]
-[ "sys", "bit_xor", "xor", "calc", 0, 1, false, false,
false ]
-[ "sys", "broadcast", "create function \"broadcast\" (p inet) returns
inet external name inet.\"broadcast\";", "inet", 1, 1, false,
false, false ]
-[ "sys", "ceil", "ceil", "mmath", 0, 1, false, false,
false ]
-[ "sys", "ceil", "ceil", "mmath", 0, 1, false, false,
false ]
-[ "sys", "ceiling", "ceil", "mmath", 0, 1, false,
false, false ]
-[ "sys", "ceiling", "ceil", "mmath", 0, 1, false,
false, false ]
-[ "sys", "char_length", "length", "str", 0, 1, false,
false, false ]
-[ "sys", "char_length", "length", "str", 0, 1, false,
false, false ]
-[ "sys", "char_length", "length", "str", 0, 1, false,
false, false ]
-[ "sys", "character_length", "length", "str", 0, 1,
false, false, false ]
-[ "sys", "character_length", "length", "str", 0, 1,
false, false, false ]
-[ "sys", "character_length", "length", "str", 0, 1,
false, false, false ]
-[ "sys", "charindex", "locate", "str", 0, 1, false,
false, false ]
-[ "sys", "charindex", "locate", "str", 0, 1, false,
false, false ]
-[ "sys", "charindex", "locate", "str", 0, 1, false,
false, false ]
-[ "sys", "charindex", "locate", "str", 0, 1, false,
false, false ]
-[ "sys", "charindex", "locate", "str", 0, 1, false,
false, false ]
-[ "sys", "charindex", "locate", "str", 0, 1, false,
false, false ]
-[ "sys", "clearrejects", "create procedure sys.clearrejects() external
name sql.copy_rejects_clear;", "sql", 1, 2, true, false, false
]
-[ "sys", "code", "unicode", "str", 0, 1, false, false,
false ]
-[ "sys", "code", "unicode", "str", 0, 1, false, false,
false ]
-[ "sys", "code", "unicode", "str", 0, 1, false, false,
false ]
-[ "sys", "columnsize", "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;",
"user", 2, 1, false, false, false ]
-[ "sys", "concat", "+", "calc", 0, 1, false, false,
false ]
-[ "sys", "concat", "+", "calc", 0, 1, false, false,
false ]
-[ "sys", "concat", "+", "calc", 0, 1, false, false,
false ]
-[ "sys", "contains", "create function contains(a geometry, x double,
y double) returns boolean external name geom.\"Contains\";", "geom", 1,
1, false, false, false ]
-[ "sys", "copyfrom", "copy_from", "sql", 0, 5, false,
true, false ]
-[ "sys", "copyfrom", "importTable", "sql", 0, 5, false,
true, false ]
-[ "sys", "corr", "create aggregate corr(e1 bigint, e2 bigint) returns
bigint external name \"aggr\".\"corr\";", "aggr", 1, 3, false,
false, false ]
-[ "sys", "corr", "create aggregate corr(e1 double, e2 double) returns
double external name \"aggr\".\"corr\";", "aggr", 1, 3, false,
false, false ]
-[ "sys", "corr", "create aggregate corr(e1 hugeint, e2 hugeint) returns
hugeint external name \"aggr\".\"corr\";", "aggr", 1, 3, false,
false, false ]
-[ "sys", "corr", "create aggregate corr(e1 integer, e2 integer) returns
integer external name \"aggr\".\"corr\";", "aggr", 1, 3, false,
false, false ]
-[ "sys", "corr", "create aggregate corr(e1 real, e2 real) returns real
external name \"aggr\".\"corr\";", "aggr", 1, 3, false,
false, false ]
-[ "sys", "corr", "create aggregate corr(e1 smallint, e2 smallint)
returns smallint external name \"aggr\".\"corr\";", "aggr", 1, 3,
false, false, false ]
-[ "sys", "corr", "create aggregate corr(e1 tinyint, e2 tinyint) returns
tinyint external name \"aggr\".\"corr\";", "aggr", 1, 3, false,
false, false ]
-[ "sys", "cos", "cos", "mmath", 0, 1, false, false,
false ]
-[ "sys", "cos", "cos", "mmath", 0, 1, false, false,
false ]
-[ "sys", "cosh", "cosh", "mmath", 0, 1, false, false,
false ]
-[ "sys", "cosh", "cosh", "mmath", 0, 1, false, false,
false ]
-[ "sys", "cot", "cot", "mmath", 0, 1, false, false,
false ]
-[ "sys", "cot", "cot", "mmath", 0, 1, false, false,
false ]
-[ "sys", "count", "count", "aggr", 0, 3, false,
false, false ]
-[ "sys", "count_no_nil", "count_no_nil", "aggr", 0, 3, false,
false, false ]
-[ "sys", "createorderindex", "create procedure
sys.createorderindex(sys string, tab string, col string) external name
sql.createorderindex;", "sql", 1, 2, true, false, false ]
-[ "sys", "curdate", "current_date", "mtime", 0, 1,
false, false, false ]
-[ "sys", "current_date", "current_date", "mtime", 0, 1,
false, false, false ]
-[ "sys", "current_time", "current_time", "mtime", 0, 1,
false, false, false ]
-[ "sys", "current_timestamp", "current_timestamp", "mtime",
0, 1, false, false, false ]
-[ "sys", "curtime", "current_time", "mtime", 0, 1,
false, false, false ]
-[ "sys", "date_to_str", "create function date_to_str(d date, format
string) returns string external name mtime.\"date_to_str\";", "mtime",
1, 1, false, false, false ]
-[ "sys", "day", "day", "mtime", 0, 1, false, false,
false ]
-[ "sys", "day", "day", "mtime", 0, 1, false, false,
false ]
-[ "sys", "day", "day", "mtime", 0, 1, false, false,
false ]
-[ "sys", "day", "day", "mtime", 0, 1, false, false,
false ]
-[ "sys", "dayofmonth", "day", "mtime", 0, 1, false,
false, false ]
-[ "sys", "dayofweek", "dayofweek", "mtime", 0, 1,
false, false, false ]
-[ "sys", "dayofyear", "dayofyear", "mtime", 0, 1,
false, false, false ]
-[ "sys", "db_users", "CREATE FUNCTION db_users () RETURNS TABLE(name
varchar(2048)) EXTERNAL NAME sql.db_users;", "sql", 2, 5, false,
false, false ]
-[ "sys", "debug", "create function sys.debug(debug int) returns
integer external name mdb.\"setDebug\";", "mdb", 1, 1, false,
false, false ]
-[ "sys", "degrees", "create function degrees(r double) returns
double return r*180/pi();", "user", 2, 1, false, false, false ]
-[ "sys", "dense_rank", "dense_rank", "sql", 0, 6, false,
false, false ]
-[ "sys", "dependencies_columns_on_functions", "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);", "user", 2,
5, false, false, false ]
-[ "sys", "dependencies_columns_on_indexes", "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));", "user", 2, 5, false, false, false ]
-[ "sys", "dependencies_columns_on_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);", "user",
2, 5, false, false, false ]
-[ "sys", "dependencies_columns_on_triggers", "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);", "user",
2, 5, false, false, false ]
-[ "sys", "dependencies_columns_on_views", "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);",
"user", 2, 5, false, false, false ]
-[ "sys", "dependencies_functions_on_functions", "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);", "user", 2,
5, false, false, false ]
-[ "sys", "dependencies_functions_os_triggers", "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);", "user", 2,
5, false, false, false ]
-[ "sys", "dependencies_keys_on_foreignkeys", "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);", "user", 2,
5, false, false, false ]
-[ "sys", "dependencies_owners_on_schemas", "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);", "user",
2, 5, false, false, false ]
-[ "sys", "dependencies_schemas_on_users", "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);",
"user", 2, 5, false, false, false ]
-[ "sys", "dependencies_tables_on_foreignkeys", "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);", "user", 2, 5, false, false, false ]
-[ "sys", "dependencies_tables_on_functions", "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);",
"user", 2, 5, false, false, false ]
-[ "sys", "dependencies_tables_on_indexes", "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);", "user", 2, 5, false,
false, false ]
-[ "sys", "dependencies_tables_on_triggers", "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));", "user", 2, 5, false, false, false ]
-[ "sys", "dependencies_tables_on_views", "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);",
"user", 2, 5, false, false, false ]
-[ "sys", "dependencies_views_on_functions", "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);",
"user", 2, 5, false, false, false ]
-[ "sys", "dependencies_views_on_triggers", "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);", "user", 2, 5, false, false, false ]
-[ "sys", "diff", "diff", "sql", 0, 6, false, false, false
]
-[ "sys", "diff", "diff", "sql", 0, 6, false, false, false
]
-[ "sys", "difference", "stringdiff", "txtsim", 0, 1,
false, false, false ]
-[ "sys", "difference", "stringdiff", "txtsim", 0, 1,
false, false, false ]
-[ "sys", "difference", "stringdiff", "txtsim", 0, 1,
false, false, false ]
-[ "sys", "droporderindex", "create procedure
sys.droporderindex(sys string, tab string, col string) external name
sql.droporderindex;", "sql", 1, 2, true, false, false ]
-[ "sys", "editdistance", "editdistance", "txtsim", 0, 1,
false, false, false ]
-[ "sys", "editdistance", "editdistance", "txtsim", 0, 1,
false, false, false ]
-[ "sys", "editdistance", "editdistance", "txtsim", 0, 1,
false, false, false ]
-[ "sys", "editdistance2", "editdistance2", "txtsim",
0, 1, false, false, false ]
-[ "sys", "editdistance2", "editdistance2", "txtsim",
0, 1, false, false, false ]
-[ "sys", "editdistance2", "editdistance2", "txtsim",
0, 1, false, false, false ]
-[ "sys", "env", "CREATE FUNCTION env () RETURNS TABLE(name
varchar(1024), value varchar(2048)) EXTERNAL NAME sql.sql_environment;",
"sql", 2, 5, false, false, false ]
-[ "sys", "environment", "create function sys.environment() returns
table (\"name\" string, value string) external name sql.sql_environment;",
"sql", 1, 5, false, false, false ]
-[ "sys", "epoch", "create function sys.\"epoch\"(sec bigint)
returns timestamp external name timestamp.\"epoch\";", "timestamp", 1,
1, false, false, false ]
-[ "sys", "epoch", "create function sys.\"epoch\"(sec int) returns
timestamp external name timestamp.\"epoch\";", "timestamp", 1, 1,
false, false, false ]
-[ "sys", "epoch", "create function sys.\"epoch\"(ts timestamp
with time zone) returns int external name timestamp.\"epoch\";",
"timestamp", 1, 1, false, false, false ]
-[ "sys", "epoch", "create function sys.\"epoch\"(ts timestamp)
returns int external name timestamp.\"epoch\";", "timestamp", 1, 1,
false, false, false ]
-[ "sys", "evalalgebra", "create procedure sys.evalalgebra(ra_stmt
string, opt bool) external name sql.\"evalAlgebra\";", "sql", 1,
2, true, false, false ]
-[ "sys", "exist", "exist", "aggr", 0, 3, false,
false, false ]
-[ "sys", "exp", "exp", "mmath", 0, 1, false, false,
false ]
-[ "sys", "exp", "exp", "mmath", 0, 1, false, false,
false ]
-[ "sys", "fitsattach", "create procedure fitsattach(fname string)
external name fits.attach;", "fits", 1, 2, true, false, false ]
-[ "sys", "fitsload", "create procedure fitsload(tname string)
external name fits.load;", "fits", 1, 2, true, false, false ]
-[ "sys", "floor", "floor", "mmath", 0, 1,
false, false, false ]
-[ "sys", "floor", "floor", "mmath", 0, 1,
false, false, false ]
-[ "sys", "flush_log", "create procedure sys.flush_log () external
name sql.\"flush_log\";", "sql", 1, 2, true, false, false ]
-[ "sys", "fuse", "create function fuse(one bigint, two bigint) returns
hugeint external name udf.fuse;", "udf", 1, 1, false, false, false
]
-[ "sys", "fuse", "create function fuse(one integer, two integer) returns
bigint external name udf.fuse;", "udf", 1, 1, false, false,
false ]
-[ "sys", "fuse", "create function fuse(one smallint, two smallint)
returns integer external name udf.fuse;", "udf", 1, 1, false,
false, false ]
-[ "sys", "fuse", "create function fuse(one tinyint, two tinyint) returns
smallint external name udf.fuse;", "udf", 1, 1, false, false,
false ]
-[ "sys", "generate_series", "create function
sys.generate_series(first bigint, last bigint) returns table (value bigint)
external name generator.series;", "generator", 1, 5, false,
false, false ]
-[ "sys", "generate_series", "create function
sys.generate_series(first bigint, last bigint, stepsize bigint) returns table
(value bigint) external name generator.series;", "generator", 1, 5,
false, false, false ]
-[ "sys", "generate_series", "create 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;", "generator", 1, 5, false, false, false
]
-[ "sys", "generate_series", "create function
sys.generate_series(first double, last double, stepsize double) returns table
(value double) external name generator.series;", "generator", 1, 5,
false, false, false ]
-[ "sys", "generate_series", "create function
sys.generate_series(first hugeint, last hugeint) returns table (value hugeint)
external name generator.series;", "generator", 1, 5, false,
false, false ]
-[ "sys", "generate_series", "create function
sys.generate_series(first hugeint, last hugeint, stepsize hugeint) returns
table (value hugeint) external name generator.series;", "generator", 1,
5, false, false, false ]
-[ "sys", "generate_series", "create function
sys.generate_series(first int, last int) returns table (value int) external
name generator.series;", "generator", 1, 5, false, false,
false ]
-[ "sys", "generate_series", "create function
sys.generate_series(first int, last int, stepsize int) returns table (value
int) external name generator.series;", "generator", 1, 5,
false, false, false ]
-[ "sys", "generate_series", "create function
sys.generate_series(first real, last real, stepsize real) returns table (value
real) external name generator.series;", "generator", 1, 5, false,
false, false ]
-[ "sys", "generate_series", "create function
sys.generate_series(first smallint, last smallint) returns table (value
smallint) external name generator.series;", "generator", 1, 5,
false, false, false ]
-[ "sys", "generate_series", "create function
sys.generate_series(first smallint, last smallint, stepsize smallint) returns
table (value smallint) external name generator.series;", "generator", 1,
5, false, false, false ]
-[ "sys", "generate_series", "create function
sys.generate_series(first timestamp, last timestamp, stepsize interval second)
returns table (value timestamp) external name generator.series;",
"generator", 1, 5, false, false, false ]
-[ "sys", "generate_series", "create function
sys.generate_series(first tinyint, last tinyint) returns table (value tinyint)
external name generator.series;", "generator", 1, 5, false,
false, false ]
-[ "sys", "generate_series", "create function
sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns
table (value tinyint) external name generator.series;", "generator", 1,
5, false, false, false ]
-[ "sys", "geometrytype", "create function geometrytype(geom geometry)
returns string external name geom.\"GeometryType1\";", "geom", 1, 1,
false, false, false ]
-[ "sys", "get_type", "create function get_type(info integer, format
integer) returns string external name geom.\"getType\";", "geom", 1,
1, false, false, false ]
-[ "sys", "get_value_for", "get_value", "sql", 0, 1,
false, false, false ]
-[ "sys", "getanchor", "create function getanchor(theurl url) returns
string external name url.\"getAnchor\";", "url", 1, 1, false,
false, false ]
-[ "sys", "getbasename", "create function getbasename(theurl url)
returns string external name url.\"getBasename\";", "url", 1, 1,
false, false, false ]
-[ "sys", "getcontent", "create function getcontent(theurl url) returns
string external name url.\"getContent\";", "url", 1, 1, false,
false, false ]
-[ "sys", "getcontext", "create function getcontext(theurl url) returns
string external name url.\"getContext\";", "url", 1, 1, false,
false, false ]
-[ "sys", "getdomain", "create function getdomain(theurl url) returns
string external name url.\"getDomain\";", "url", 1, 1, false,
false, false ]
-[ "sys", "getextension", "create function getextension(theurl url)
returns string external name url.\"getExtension\";", "url", 1, 1,
false, false, false ]
-[ "sys", "getfile", "create function getfile(theurl url) returns
string external name url.\"getFile\";", "url", 1, 1, false,
false, false ]
-[ "sys", "gethost", "create function gethost(theurl url) returns
string external name url.\"getHost\";", "url", 1, 1, false,
false, false ]
-[ "sys", "getport", "create function getport(theurl url) returns
string external name url.\"getPort\";", "url", 1, 1, false,
false, false ]
-[ "sys", "getproj4", "create function getproj4(srid_in integer)
returns string begin return select proj4text from spatial_ref_sys where
srid=srid_in; end;", "user", 2, 1, false, false, false ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
