Changeset: b217444852a5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b217444852a5
Modified Files:
clients/Tests/exports.stable.out
monetdb5/mal/mal_namespace.h
sql/server/rel_psm.c
sql/storage/store.c
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.int128
Branch: default
Log Message:
Removed dead code since removal of embedded languages.
diffs (truncated from 4302 to 300 lines):
diff --git a/clients/Tests/exports.stable.out b/clients/Tests/exports.stable.out
--- a/clients/Tests/exports.stable.out
+++ b/clients/Tests/exports.stable.out
@@ -1243,7 +1243,6 @@ const char subavgRef[];
const char subcountRef[];
const char subdeltaRef[];
const char subdiffRef[];
-const char subeval_aggrRef[];
const char subgroupRef[];
const char subgroupdoneRef[];
const char submaxRef[];
diff --git a/monetdb5/mal/mal_namespace.h b/monetdb5/mal/mal_namespace.h
--- a/monetdb5/mal/mal_namespace.h
+++ b/monetdb5/mal/mal_namespace.h
@@ -238,7 +238,6 @@
FUNC(subcount); \
FUNC(subdelta); \
FUNC(subdiff); \
- FUNC(subeval_aggr); \
FUNC(subgroup); \
FUNC(subgroupdone); \
FUNC(submax); \
diff --git a/sql/server/rel_psm.c b/sql/server/rel_psm.c
--- a/sql/server/rel_psm.c
+++ b/sql/server/rel_psm.c
@@ -1014,40 +1014,7 @@ rel_create_func(sql_query *query, dlist
if (lang > FUNC_LANG_SQL && has_generic_decimal_result(restype))
return sql_error(sql, 02, SQLSTATE(42000) "CREATE %s: the
function '%s' returns a generic DECIMAL type, UDFs require precision and
scale", F, fname);
if (body && LANG_EXT(lang)) {
- const char *lang_body = body->h->data.sval, *mod = "unknown",
*slang = "Unknown", *imp = "Unknown";
- switch (lang) {
- default:
- return sql_error(sql, 01, SQLSTATE(42000) "Function
language without a MAL backend");
- }
- switch(type) {
- case F_AGGR:
- imp = "eval_aggr";
- break;
- case F_LOADER:
- imp = "eval_loader";
- break;
- default: /* for every other function type at the moment */
- imp = "eval";
- }
-
- if (type == F_LOADER)
- return sql_error(sql, 01, SQLSTATE(42000) "CREATE %s:
No longer supported", F);
-
- sql->params = NULL;
- if (create) {
- bit side_effect = (list_empty(restype) || (!vararg &&
list_empty(l))); /* TODO make this more precise? */
- switch (mvc_create_func(&f, sql, sql->sa, s, fname, l,
restype, type, lang, mod, imp, lang_body, (type == F_LOADER)?TRUE:FALSE,
vararg, FALSE, side_effect, order_required, opt_order)) {
- case -1:
- return sql_error(sql, 01,
SQLSTATE(HY013) MAL_MALLOC_FAIL);
- case -2:
- case -3:
- return sql_error(sql, 01,
SQLSTATE(42000) "CREATE %s: transaction conflict detected", F);
- default:
- break;
- }
- } else if (!sf) {
- return sql_error(sql, 01, SQLSTATE(42000) "CREATE %s:
%s function %s.%s not bound", F, slang, s->base.name, fname);
- }
+ return sql_error(sql, 01, SQLSTATE(42000) "Function language
without a MAL backend");
} else if (body) { /* SQL implementation */
sql_arg *ra = (restype && type !=
F_UNION)?restype->h->data:NULL;
list *b = NULL;
diff --git a/sql/storage/store.c b/sql/storage/store.c
--- a/sql/storage/store.c
+++ b/sql/storage/store.c
@@ -1019,16 +1019,7 @@ load_func(sql_trans *tr, sql_schema *s,
t->imp = NULL;
}
if (LANG_EXT(t->lang)) { /* instantiate functions other than sql and
mal */
- switch(t->type) {
- case F_AGGR:
- t->imp =_STRDUP("eval_aggr");
- break;
- case F_LOADER:
- t->imp =_STRDUP("eval_loader");
- break;
- default: /* for every other function type at the moment */
- t->imp =_STRDUP("eval");
- }
+ t->imp =_STRDUP("eval");
}
if (order_spec == 2)
t->order_required = true;
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
@@ -434,7 +434,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s, ., ., .s, . # table_name
% %1, name, authorization, owner, system, comment # name
% varchar, varchar, varchar, varchar, boolean,
varchar # type
-% 11, 18, 8, 7, 5, 28 # length
+% -1, -1, -1, -1, 5, -1 # length
[ "sys.schemas", "information_schema", "monetdb", "monetdb",
true, "ISO/IEC 9075-11 SQL/Schemata" ]
[ "sys.schemas", "json", "monetdb", "monetdb", true, NULL
]
[ "sys.schemas", "logging", "monetdb", "monetdb", true,
NULL ]
@@ -444,7 +444,7 @@ select 'null in fkeys.delete_action', de
% .%25, .s, .t, ., ., .t, ., ., . #
table_name
% %25, name, name, query, type, system, commit_action, access, comment
# name
% varchar, varchar, varchar, varchar, varchar,
boolean, varchar, varchar, varchar # type
-% 11, 18, 34, 6812, 5, 5, 8, 8, 0 # length
+% -1, -1, -1, -1, -1, 5, -1, -1, -1 # length
[ "sys._tables", "information_schema", "character_sets", "create
view information_schema.character_sets as select cast(null as varchar(1)) as
character_set_catalog, cast(null as varchar(1)) as character_set_schema,
cast('UTF-8' as varchar(16)) as character_set_name, cast('ISO/IEC 10646:2021'
as varchar(20)) as character_repertoire, cast('UTF-8' as varchar(16)) as
form_of_use, cast(null as varchar(1)) as default_collate_catalog, cast(null as
varchar(1)) as default_collate_schema, cast(null as varchar(1)) as
default_collate_name;", "VIEW", true, "COMMIT", "WRITABLE", NULL
]
[ "sys._tables", "information_schema", "check_constraints", "create
view information_schema.check_constraints as select cast(null as varchar(1)) as
constraint_catalog, s.\"name\" as constraint_schema, k.\"name\" as
constraint_name, cast(sys.check_constraint(s.\"name\", k.\"name\") as
varchar(2048)) as check_clause, t.\"schema_id\" as schema_id, t.\"id\" as
table_id, t.\"name\" as table_name, k.\"id\" as key_id from (select sk.\"id\",
sk.\"table_id\", sk.\"name\" from sys.\"keys\" sk where sk.\"type\" = 4 union
all select tk.\"id\", tk.\"table_id\", tk.\"name\" from tmp.\"keys\" tk where
tk.\"type\" = 4) k inner join (select st.\"id\", st.\"schema_id\", st.\"name\"
from sys.\"_tables\" st union all select tt.\"id\", tt.\"schema_id\",
tt.\"name\" from tmp.\"_tables\" tt) t on k.\"table_id\" = t.\"id\" inner join
sys.\"schemas\" s on t.\"schema_id\" = s.\"id\" order by s.\"name\",
t.\"name\", k.\"name\";", "VIEW", true, "COMMIT", "WRITABLE",
NULL ]
[ "sys._tables", "information_schema", "columns", "create view
information_schema.columns as select cast(null as varchar(1)) as table_catalog,
s.\"name\" as table_schema, t.\"name\" as table_name, c.\"name\" as
column_name, cast(1 + c.\"number\" as int) as ordinal_position, c.\"default\"
as column_default, cast(sys.ifthenelse(c.\"null\", 'YES', 'NO') as varchar(3))
as is_nullable, cast(sys.\"sql_datatype\"(c.\"type\", c.\"type_digits\",
c.\"type_scale\", true, true) as varchar(1024)) as data_type,
cast(sys.ifthenelse(c.\"type\" in ('varchar','clob','char','json','url','xml')
and c.\"type_digits\" > 0, c.\"type_digits\", null) as int) as
character_maximum_length, cast(sys.ifthenelse(c.\"type\" in
('varchar','clob','char','json','url','xml') and c.\"type_digits\" > 0, 4 *
cast(c.\"type_digits\" as bigint), null) as bigint) as character_octet_length,
cast(sys.ifthenelse(c.\"type\" in
('int','smallint','tinyint','bigint','hugeint','float','real','double','decimal','numeric','oid'),
c.\"
type_digits\", null) as int) as numeric_precision,
cast(sys.ifthenelse(c.\"type\" in
('int','smallint','tinyint','bigint','hugeint','float','real','double','oid'),
2, sys.ifthenelse(c.\"type\" in ('decimal','numeric'), 10, null)) as int) as
numeric_precision_radix, cast(sys.ifthenelse(c.\"type\" in
('int','smallint','tinyint','bigint','hugeint','float','real','double','decimal','numeric','oid'),
c.\"type_scale\", null) as int) as numeric_scale,
cast(sys.ifthenelse(c.\"type\" in
('date','timestamp','timestamptz','time','timetz'),
sys.ifthenelse(c.\"type_scale\" > 0, c.\"type_scale\" -1, 0), null) as int) as
datetime_precision, cast(sys.ifthenelse(c.\"type\" in
('day_interval','month_interval','sec_interval'),
sys.\"sql_datatype\"(c.\"type\", c.\"type_digits\", c.\"type_scale\", true,
true), null) as varchar(40)) as interval_type, cast(case c.\"type\" when
'day_interval' then 0 when 'month_interval' then 0 when 'sec_interval' then
(sys.ifthenelse(c.\"type_digits\" in (7, 10, 12, 13),
sys.ifthenelse(c.\"type_scale\" > 0, c.\"type_scale\", 3), 0)) else null end
as int) as interval_precision, cast(null as varchar(1)) as
character_set_catalog, cast(null as varchar(1)) as character_set_schema,
cast(sys.ifthenelse(c.\"type\" in ('varchar','clob','char','json','url','xml'),
'UTF-8', null) as varchar(16)) as character_set_name, cast(null as varchar(1))
as collation_catalog, cast(null as varchar(1)) as collation_schema, cast(null
as varchar(1)) as collation_name, cast(null as varchar(1)) as domain_catalog,
cast(null as varchar(1)) as domain_schema, cast(null as varchar(1)) as
domain_name, cast(null as varchar(1)) as udt_catalog, cast(null as varchar(1))
as udt_schema, cast(null as varchar(1)) as udt_name, cast(null as varchar(1))
as scope_catalog, cast(null as varchar(1)) as scope_schema, cast(null as
varchar(1)) as scope_name, cast(null as int) as maximum_cardinality, cast(null
as varchar(1)) as dtd_identifier, cast('NO' as varchar(3)) as
is_self_referencing, cast(sys.i
fthenelse(seq.\"name\" is null or c.\"null\", 'NO', 'YES') as varchar(3)) as
is_identity, seq.\"name\" as identity_generation, seq.\"start\" as
identity_start, seq.\"increment\" as identity_increment, seq.\"maxvalue\" as
identity_maximum, seq.\"minvalue\" as identity_minimum,
cast(sys.ifthenelse(seq.\"name\" is null, null, sys.ifthenelse(seq.\"cycle\",
'YES', 'NO')) as varchar(3)) as identity_cycle,
cast(sys.ifthenelse(seq.\"name\" is null, 'NO', 'YES') as varchar(3)) as
is_generated, cast(sys.ifthenelse(seq.\"name\" is null, null, c.\"default\") as
varchar(1024)) as generation_expression, cast('NO' as varchar(3)) as
is_system_time_period_start, cast('NO' as varchar(3)) as
is_system_time_period_end, cast('NO' as varchar(3)) as
system_time_period_timestamp_generation, cast(sys.ifthenelse(t.\"type\" in
(0,3,7,20,30), 'YES', 'NO') as varchar(3)) as is_updatable, cast(null as
varchar(1)) as declared_data_type, cast(null as int) as
declared_numeric_precision, cast(null as int) as declare
d_numeric_scale, t.\"schema_id\" as schema_id, c.\"table_id\" as table_id,
c.\"id\" as column_id, seq.\"id\" as sequence_id, t.\"system\" as is_system,
cm.\"remark\" as comments from sys.\"columns\" c inner join sys.\"tables\" t on
c.\"table_id\" = t.\"id\" inner join sys.\"schemas\" s on t.\"schema_id\" =
s.\"id\" left outer join sys.\"comments\" cm on c.\"id\" = cm.\"id\" left outer
join sys.\"sequences\" seq on ((seq.\"name\"||'\"') = substring(c.\"default\",
3 + sys.\"locate\"('\".\"seq_',c.\"default\",14))) order by s.\"name\",
t.\"name\", c.\"number\";", "VIEW", true, "COMMIT", "WRITABLE",
NULL ]
@@ -592,7 +592,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s, .t, .c, .c, .c, .c, .c, .c, .c,
.c, . # table_name
% %1, name, name, name, type, type_digits, type_scale,
default, null, number, storage, comment # name
% varchar, varchar, varchar, varchar, varchar,
int, int, varchar, boolean, int, varchar, varchar
# type
-% 12, 18, 34, 39, 9, 7, 1, 5, 5, 2,
0, 0 # length
+% -1, -1, -1, -1, -1, -1, -1, -1, 5, -1,
-1, -1 # length
[ "sys._columns", "information_schema", "character_sets",
"character_set_catalog", "varchar", 1, 0, NULL, true,
0, NULL, NULL ]
[ "sys._columns", "information_schema", "character_sets",
"character_set_schema", "varchar", 1, 0, NULL, true, 1,
NULL, NULL ]
[ "sys._columns", "information_schema", "character_sets",
"character_set_name", "varchar", 16, 0, NULL, true, 2,
NULL, NULL ]
@@ -1698,23 +1698,23 @@ select 'null in fkeys.delete_action', de
% .%1, .t, .c, .p # table_name
% %1, name, name, expression # name
% varchar, varchar, varchar, varchar # type
-% 0, 0, 0, 0 # length
+% -1, -1, -1, -1 # length
% .%1, .t, .p, .r, .r, .r # table_name
% %1, name, expression, minimum, maximum, with_nulls #
name
% varchar, varchar, varchar, varchar, varchar,
boolean # type
-% 0, 0, 0, 0, 0, 5 # length
+% -1, -1, -1, -1, -1, 5 # length
% .%1, .t, .p, .v # table_name
% %1, name, expression, value # name
% varchar, varchar, varchar, varchar # type
-% 0, 0, 0, 0 # length
+% -1, -1, -1, -1 # length
% .%6, .x, .x, .x # table_name
% %6, sname, name, modfunc # name
% varchar, varchar, varchar, varchar # type
-% 0, 0, 0, 0 # length
+% -1, -1, -1, -1 # length
% .%1, .s, .f, ., ., .f, .fl, ., .f, .f,
.f, .f, ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., . # table_name
% %1, name, name, system, query, mod, language_name, func_type,
side_effect, varres, vararg, semantics, comment, name0, type0,
type_digits0, type_scale0, inout0, name1, type1, type_digits1,
type_scale1, inout1, name2, type2, type_digits2, type_scale2, inout2,
name3, type3, type_digits3, type_scale3, inout3, name4, type4,
type_digits4, type_scale4, inout4, name5, type5, type_digits5,
type_scale5, inout5, name6, type6, type_digits6, type_scale6, inout6,
name7, type7, type_digits7, type_scale7, inout7, name8, type8,
type_digits8, type_scale8, inout8, name9, type9, type_digits9,
type_scale9, inout9, name10, type10, type_digits10, type_scale10,
inout10, name11, type11, type_digits11, type_scale11, inout11,
name12, type12, type_digits12, type_scale12, inout12, name13, type13,
type_digits13, type_scale13, inout13, name14, type14, type_digits14,
type_scale14, inout14, name15, type15, type_digits15, type_scale15,
inout15 # name
% varchar, varchar, varchar, varchar, varchar,
varchar, varchar, varchar, boolean, boolean,
boolean, boolean, varchar, varchar, varchar,
int, int, varchar, varchar, varchar, int, int,
varchar, varchar, varchar, int, int, varchar,
varchar, varchar, int, int, varchar, varchar,
varchar, int, int, varchar, varchar, varchar,
int, int, varchar, varchar, varchar, int, int,
varchar, varchar, varchar, int, int, varchar,
varchar, varchar, int, int, varchar, varchar,
varchar, int, int, varchar, varchar, varchar,
int, int, varchar, varchar, varchar, int, int,
varchar, varchar, varchar, int, int, varchar,
varchar, varchar, int, int, varchar, varchar,
varchar, int, int, varchar, varchar, varchar,
int, int, varchar # type
-% 13, 7, 37, 6, 3806, 9, 10, 26, 5, 5,
5, 5, 0, 11, 14, 4, 1, 3, 16, 14,
4, 1, 3, 16, 14, 4, 1, 3, 27, 14,
4, 1, 3, 9, 9, 4, 1, 3, 14, 7,
4, 1, 3, 12, 9, 2, 1, 3, 11, 7,
2, 1, 3, 11, 7, 2, 1, 3, 10, 7,
2, 1, 3, 9, 7, 2, 1, 3, 8, 7,
1, 1, 3, 11, 7, 2, 1, 3, 6, 7,
4, 1, 3, 9, 7, 4, 1, 3, 6, 7,
4, 1, 3 # length
+% -1, -1, -1, -1, -1, -1, -1, -1, 5, 5,
5, 5, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
-1, -1, -1 # length
[ "sys.functions", "json", "filter", "SYSTEM", "create
function json.filter(js json, name bigint) returns json external name
json.filter;", "json", "MAL", "Scalar function", false, false,
false, true, NULL, "result", "json", 0, 0, "out", "js",
"json", 0, 0, "in", "name", "bigint", 63, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "json", "filter", "SYSTEM", "create
function json.filter(js json, name integer) returns json external name
json.filter;", "json", "MAL", "Scalar function", false, false, false,
true, NULL, "result", "json", 0, 0, "out", "js",
"json", 0, 0, "in", "name", "int", 31, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "json", "filter", "SYSTEM", "create
function json.filter(js json, name tinyint) returns json external name
json.filter;", "json", "MAL", "Scalar function", false, false, false,
true, NULL, "result", "json", 0, 0, "out", "js",
"json", 0, 0, "in", "name", "tinyint", 7, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
@@ -2879,7 +2879,7 @@ select 'null in fkeys.delete_action', de
% .%1, ., . # table_name
% %1, name, grantor # name
% varchar, varchar, varchar # type
-% 9, 9, 7 # length
+% -1, -1, -1 # length
[ "sys.auths", ".snapshot", "monetdb" ]
[ "sys.auths", "monetdb", NULL ]
[ "sys.auths", "public", NULL ]
@@ -2887,13 +2887,13 @@ select 'null in fkeys.delete_action', de
% .%1, .u, .u, .s, .u, .u, .u, .u, . # table_name
% %1, name, fullname, name, schema_path, max_memory,
max_workers, optimizer, default_role # name
% varchar, varchar, varchar, varchar, varchar,
bigint, int, varchar, varchar # type
-% 16, 9, 13, 3, 5, 1, 1, 12, 9 # length
+% -1, -1, -1, -1, -1, -1, -1, -1, -1 # length
[ "sys.db_user_info", ".snapshot", "Snapshot User", "sys",
"\"sys\"", 0, 0, "default_pipe", ".snapshot" ]
[ "sys.db_user_info", "monetdb", "MonetDB Admin", "sys",
"\"sys\"", 0, 0, "default_pipe", "monetdb" ]
% .%1, .s1, .f1, .s2, .f2, .dt # table_name
% %1, name, name, name, name, dependency_type_name # name
% varchar, varchar, varchar, varchar, varchar,
varchar # type
-% 25, 3, 17, 3, 37, 9 # length
+% -1, -1, -1, -1, -1, -1 # length
[ "function used by function", "sys", "date_to_str", "sys", "dayname",
"FUNCTION" ]
[ "function used by function", "sys", "describe_type", "sys",
"describe_columns", "FUNCTION" ]
[ "function used by function", "sys", "sql_datatype", "sys",
"describe_type", "FUNCTION" ]
@@ -2920,7 +2920,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s1, .t, .s2, .f, .dt # table_name
% %1, name, name, name, name, dependency_type_name # name
% varchar, varchar, varchar, varchar, varchar,
varchar # type
-% 22, 3, 26, 3, 37, 9 # length
+% -1, -1, -1, -1, -1, -1 # length
[ "table used by function", "sys", "db_user_info", "sys", "db_users",
"FUNCTION" ]
[ "table used by function", "sys", "_columns", "sys",
"describe_columns", "FUNCTION" ]
[ "table used by function", "sys", "_tables", "sys",
"describe_columns", "FUNCTION" ]
@@ -2979,7 +2979,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s1, .t, .c, .s2, .f, .dt # table_name
% %1, name, name, name, name, name, dependency_type_name # name
% varchar, varchar, varchar, varchar, varchar,
varchar, varchar # type
-% 23, 3, 26, 21, 3, 37, 9 # length
+% -1, -1, -1, -1, -1, -1, -1 # length
[ "column used by function", "sys", "db_user_info", "name", "sys",
"db_users", "FUNCTION" ]
[ "column used by function", "sys", "_columns", "default", "sys",
"describe_columns", "FUNCTION" ]
[ "column used by function", "sys", "_columns", "id", "sys",
"describe_columns", "FUNCTION" ]
@@ -3118,7 +3118,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s1, .f1, .s2, .t2, .dt # table_name
% %1, name, name, name, name, dependency_type_name # name
% varchar, varchar, varchar, varchar, varchar,
varchar # type
-% 21, 7, 37, 18, 26, 4 # length
+% -1, -1, -1, -1, -1, -1 # length
[ "function used by view", "sys", "check_constraint",
"information_schema", "check_constraints", "VIEW" ]
[ "function used by view", "sys", "sql_datatype", "information_schema",
"columns", "VIEW" ]
[ "function used by view", "sys", "sql_datatype", "information_schema",
"parameters", "VIEW" ]
@@ -3207,7 +3207,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s1, .t1, .s2, .t2, .dt # table_name
% %1, name, name, name, name, dependency_type_name # name
% varchar, varchar, varchar, varchar, varchar,
varchar # type
-% 18, 3, 27, 18, 34, 4 # length
+% -1, -1, -1, -1, -1, -1 # length
[ "table used by view", "sys", "_tables", "information_schema",
"check_constraints", "VIEW" ]
[ "table used by view", "sys", "keys", "information_schema",
"check_constraints", "VIEW" ]
[ "table used by view", "sys", "schemas", "information_schema",
"check_constraints", "VIEW" ]
@@ -3474,7 +3474,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s1, .t1, .c1, .s2, .t2, .dt # table_name
% %1, name, name, name, name, name, dependency_type_name # name
% varchar, varchar, varchar, varchar, varchar,
varchar, varchar # type
-% 19, 3, 27, 21, 18, 34, 4 # length
+% -1, -1, -1, -1, -1, -1, -1 # length
[ "column used by view", "sys", "_tables", "id",
"information_schema", "check_constraints", "VIEW" ]
[ "column used by view", "sys", "_tables", "name",
"information_schema", "check_constraints", "VIEW" ]
[ "column used by view", "sys", "_tables", "schema_id",
"information_schema", "check_constraints", "VIEW" ]
@@ -4397,7 +4397,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s1, .t1, .c1, .s2, .t2, .k2, .dt # table_name
% %1, name, name, name, name, name, name, dependency_type_name #
name
% varchar, varchar, varchar, varchar, varchar,
varchar, varchar, varchar # type
-% 18, 3, 18, 20, 3, 18, 44, 3 # length
+% -1, -1, -1, -1, -1, -1, -1, -1 # length
[ "column used by key", "sys", "comments", "id", "sys",
"comments", "comments_id_pkey", "KEY" ]
[ "column used by key", "sys", "dependency_types",
"dependency_type_id", "sys", "dependency_types",
"dependency_types_dependency_type_id_pkey", "KEY" ]
[ "column used by key", "sys", "dependency_types",
"dependency_type_name", "sys", "dependency_types",
"dependency_types_dependency_type_name_unique", "KEY" ]
@@ -4419,7 +4419,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s1, .t1, .c1, .s2, .t2, .i2, .dt # table_name
% %1, name, name, name, name, name, name, dependency_type_name #
name
% varchar, varchar, varchar, varchar, varchar,
varchar, varchar, varchar # type
-% 20, 3, 18, 20, 3, 18, 44, 5 # length
+% -1, -1, -1, -1, -1, -1, -1, -1 # length
[ "column used by index", "sys", "comments", "id", "sys",
"comments", "comments_id_pkey", "INDEX" ]
[ "column used by index", "sys", "dependency_types",
"dependency_type_id", "sys", "dependency_types",
"dependency_types_dependency_type_id_pkey", "INDEX" ]
[ "column used by index", "sys", "dependency_types",
"dependency_type_name", "sys", "dependency_types",
"dependency_types_dependency_type_name_unique", "INDEX" ]
@@ -4441,7 +4441,7 @@ select 'null in fkeys.delete_action', de
% .%1, .t, .t, .s, .f, .dt # table_name
% %1, systemname, sqlname, name, name, dependency_type_name #
name
% varchar, varchar, varchar, varchar, varchar,
varchar # type
-% 21, 5, 5, 4, 18, 4 # length
+% -1, -1, -1, -1, -1, -1 # length
[ "type used by function", "json", "json", "json", "filter", "TYPE"
]
[ "type used by function", "json", "json", "json", "filter", "TYPE"
]
[ "type used by function", "json", "json", "json", "filter", "TYPE"
]
@@ -4506,7 +4506,7 @@ select 'null in fkeys.delete_action', de
% .%1, .t, .i, .it, . # table_name
% %1, name, name, index_type_name, comment # name
% varchar, varchar, varchar, varchar, varchar # type
-% 8, 18, 44, 4, 0 # length
+% -1, -1, -1, -1, -1 # length
[ "sys.idxs", "comments", "comments_id_pkey", "Hash", NULL ]
[ "sys.idxs", "dependency_types",
"dependency_types_dependency_type_id_pkey", "Hash", NULL ]
[ "sys.idxs", "dependency_types",
"dependency_types_dependency_type_name_unique", "Hash", NULL ]
@@ -4528,7 +4528,7 @@ select 'null in fkeys.delete_action', de
% .%1, .t, .k, .kt, .k2, .k # table_name
% %1, name, name, key_type_name, name, action # name
% varchar, varchar, varchar, varchar, varchar,
int # type
-% 8, 18, 44, 11, 0, 2 # length
+% -1, -1, -1, -1, -1, -1 # length
[ "sys.keys", "comments", "comments_id_pkey", "Primary Key", NULL,
-1 ]
[ "sys.keys", "dependency_types",
"dependency_types_dependency_type_id_pkey", "Primary Key", NULL, -1
]
[ "sys.keys", "dependency_types",
"dependency_types_dependency_type_name_unique", "Unique Key", NULL, -1
]
@@ -4550,7 +4550,7 @@ select 'null in fkeys.delete_action', de
% .%2, .o, ., . # table_name
% %2, name, nr, sub # name
% varchar, varchar, varchar, varchar # type
-% 11, 20, 1, 0 # length
+% -1, -1, -1, -1 # length
[ "sys.objects", "action_id", "0", NULL ]
[ "sys.objects", "action_id", "0", NULL ]
[ "sys.objects", "dependency_type_id", "0", NULL ]
@@ -4590,13 +4590,13 @@ select 'null in fkeys.delete_action', de
% .%1, .s, .u # table_name
% %1, name, name # name
% varchar, varchar, varchar # type
-% 22, 3, 9 # length
+% -1, -1, -1 # length
[ "default schema of user", "sys", ".snapshot" ]
[ "default schema of user", "sys", "monetdb" ]
% .%1, .t, .a, .pc, .g, .p # table_name
% %1, name, name, privilege_code_name, name, grantable # name
% varchar, varchar, varchar, varchar, varchar,
int # type
-% 14, 34, 7, 6, 7, 1 # length
+% -1, -1, -1, -1, -1, -1 # length
[ "grant on table", "_columns", "public", "SELECT", NULL,
0 ]
[ "grant on table", "_tables", "public", "SELECT", NULL,
0 ]
[ "grant on table", "args", "public", "SELECT", NULL, 0
]
@@ -4703,11 +4703,11 @@ select 'null in fkeys.delete_action', de
% .%1, .t, .c, .a, .pc, .g, .p # table_name
% %1, name, name, name, privilege_code_name, name, grantable # name
% varchar, varchar, varchar, varchar, varchar,
varchar, int # type
-% 0, 0, 0, 0, 0, 0, 1 # length
+% -1, -1, -1, -1, -1, -1, -1 # length
% .%1, .s, .f, .a, .pc, .g, .p # table_name
% %1, name, name, name, privilege_code_name, name, grantable # name
% varchar, varchar, varchar, varchar, varchar,
varchar, int # type
-% 17, 7, 24, 9, 7, 7, 1 # length
+% -1, -1, -1, -1, -1, -1, -1 # length
[ "grant on function", "json", "filter", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "json", "filter", "public", "EXECUTE",
"monetdb", 0 ]
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
