Changeset: c6136096308d for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c6136096308d
Modified Files:
sql/test/emptydb-upgrade-chain/Tests/check.stable.out.32bit
sql/test/emptydb-upgrade/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.32bit
Branch: default
Log Message:
Approved after merge.
diffs (truncated from 14103 to 300 lines):
diff --git a/sql/test/emptydb-upgrade-chain/Tests/check.stable.out.32bit
b/sql/test/emptydb-upgrade-chain/Tests/check.stable.out.32bit
--- a/sql/test/emptydb-upgrade-chain/Tests/check.stable.out.32bit
+++ b/sql/test/emptydb-upgrade-chain/Tests/check.stable.out.32bit
@@ -1755,3135 +1755,1574 @@ 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
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", "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", "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_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_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 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 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 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 ]
-[ "sys", "getprotocol", "create function getprotocol(theurl url)
returns string external name url.\"getProtocol\";", "url", 1, 1,
false, false, false ]
-[ "sys", "getquery", "create function getquery(theurl url) returns
string external name url.\"getQuery\";", "url", 1, 1, false,
false, false ]
-[ "sys", "getroboturl", "create function getroboturl(theurl url)
returns string external name url.\"getRobotURL\";", "url", 1, 1,
false, false, false ]
-[ "sys", "getuser", "create function getuser(theurl url) returns
string external name url.\"getUser\";", "url", 1, 1, false,
false, false ]
-[ "sys", "has_m", "create function has_m(info integer) returns
integer external name geom.\"hasM\";", "geom", 1, 1, false,
false, false ]
-[ "sys", "has_z", "create function has_z(info integer) returns
integer external name geom.\"hasZ\";", "geom", 1, 1, false,
false, false ]
-[ "sys", "hash", "hash", "mkey", 0, 1, false, false, false
]
-[ "sys", "hashsize", "create function sys.hashsize(b boolean, i
bigint) returns bigint begin if b = true then return 8 * i; end if; return 0;
end;", "user", 2, 1, false, false, false ]
-[ "sys", "heapsize", "create 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;", "user", 2, 1,
false, false, false ]
-[ "sys", "host", "create function \"host\" (p inet) returns clob
external name inet.\"host\";", "inet", 1, 1, false, false, false
]
-[ "sys", "hostmask", "create function \"hostmask\" (p inet) returns
inet external name inet.\"hostmask\";", "inet", 1, 1, false, false,
false ]
-[ "sys", "hour", "hours", "mtime", 0, 1, false,
false, false ]
-[ "sys", "hour", "hours", "mtime", 0, 1, false,
false, false ]
-[ "sys", "hour", "hours", "mtime", 0, 1, false,
false, false ]
-[ "sys", "hour", "hours", "mtime", 0, 1, false,
false, false ]
-[ "sys", "hour", "hours", "mtime", 0, 1, false,
false, false ]
-[ "sys", "identity", "identity", "calc", 0, 1, false,
false, false ]
-[ "sys", "ifthenelse", "ifthenelse", "calc", 0, 1, false,
false, false ]
-[ "sys", "ilike", "create filter function \"ilike\"(val string,
pat string) external name algebra.\"ilike\";", "algebra", 1, 4,
false, false, false ]
-[ "sys", "ilike", "create filter function \"ilike\"(val string,
pat string, esc string) external name algebra.\"ilike\";", "algebra",
1, 4, false, false, false ]
-[ "sys", "imprintsize", "create 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;",
"user", 2, 1, false, false, false ]
-[ "sys", "in", "in", "calc", 0, 1, false, false, false
]
-[ "sys", "index", "index", "calc", 0, 1, false,
false, false ]
-[ "sys", "index", "index", "calc", 0, 1, false,
false, false ]
-[ "sys", "index", "index", "calc", 0, 1, false,
false, false ]
-[ "sys", "index", "index", "calc", 0, 1, false,
false, false ]
-[ "sys", "index", "index", "calc", 0, 1, false,
false, false ]
-[ "sys", "index", "index", "calc", 0, 1, false,
false, false ]
-[ "sys", "index", "index", "calc", 0, 1, false,
false, false ]
-[ "sys", "index", "index", "calc", 0, 1, false,
false, false ]
-[ "sys", "index", "index", "calc", 0, 1, false,
false, false ]
-[ "sys", "insert", "insert", "str", 0, 1, false,
false, false ]
-[ "sys", "insert", "insert", "str", 0, 1, false,
false, false ]
-[ "sys", "insert", "insert", "str", 0, 1, false,
false, false ]
-[ "sys", "internaltransform", "create function internaltransform(geom
geometry, srid_src integer, srid_dest integer, proj4_src string, proj4_dest
string) returns geometry external name geom.\"Transform\";", "geom", 1,
1, false, false, false ]
-[ "sys", "isaurl", "create function isaurl(theurl url) returns
bool external name url.\"isaURL\";", "url", 1, 1, false,
false, false ]
-[ "sys", "isauuid", "create function sys.isauuid(s string) returns
boolean external name uuid.\"isaUUID\";", "uuid", 1, 1, false,
false, false ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
