Changeset: ecca48ed29b5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/ecca48ed29b5
Modified Files:
sql/test/emptydb/Tests/check.stable.out.32bit
Branch: default
Log Message:
Approve 32 bit output.
diffs (truncated from 2152 to 300 lines):
diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit
b/sql/test/emptydb/Tests/check.stable.out.32bit
--- a/sql/test/emptydb/Tests/check.stable.out.32bit
+++ b/sql/test/emptydb/Tests/check.stable.out.32bit
@@ -430,7 +430,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 ]
@@ -440,7 +440,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 ]
@@ -499,7 +499,7 @@ select 'null in fkeys.delete_action', de
[ "sys._tables", "sys", "describe_partition_tables", "create view
sys.describe_partition_tables as select m_sch, m_tbl, p_sch, p_tbl, case when
p_raw_type is null then 'READ ONLY' when (p_raw_type = 'VALUES' and pvalues is
null) or (p_raw_type = 'RANGE' and minimum is null and maximum is null and
with_nulls) then 'FOR NULLS' else p_raw_type end as tpe, pvalues, minimum,
maximum, with_nulls from (with tp(\"type\", table_id) as (select
ifthenelse((table_partitions.\"type\" & 2) = 2, 'VALUES', 'RANGE'),
table_partitions.table_id from sys.table_partitions), subq(m_tid, p_mid,
\"type\", m_sch, m_tbl, p_sch, p_tbl) as (select m_t.id, p_m.id, m_t.\"type\",
m_s.name, m_t.name, p_s.name, p_m.name from sys.schemas m_s, sys._tables m_t,
sys.dependencies d, sys.schemas p_s, sys._tables p_m where m_t.\"type\" in (3,
6) and m_t.schema_id = m_s.id and m_s.name <> 'tmp' and m_t.system = false and
m_t.id = d.depend_id and d.id = p_m.id and p_m.schema_id = p_s.id order by
m_t.id, p_m.id), vals(id,val
s) as (select vp.table_id, group_concat(vp.value, ',') from
sys.value_partitions vp group by vp.table_id) select subq.m_sch, subq.m_tbl,
subq.p_sch, subq.p_tbl, tp.\"type\" as p_raw_type, case when tp.\"type\" =
'VALUES' then (select vals.vals from vals where vals.id = subq.p_mid) else null
end as pvalues, case when tp.\"type\" = 'RANGE' then (select minimum from
sys.range_partitions rp where rp.table_id = subq.p_mid) else null end as
minimum, case when tp.\"type\" = 'RANGE' then (select maximum from
sys.range_partitions rp where rp.table_id = subq.p_mid) else null end as
maximum, case when tp.\"type\" = 'VALUES' then exists(select vp.value from
sys.value_partitions vp where vp.table_id = subq.p_mid and vp.value is null)
else (select rp.with_nulls from sys.range_partitions rp where rp.table_id =
subq.p_mid) end as with_nulls from subq left outer join tp on subq.m_tid =
tp.table_id) as tmp_pi;", "VIEW", true, "COMMIT", "WRITABLE",
NULL ]
[ "sys._tables", "sys", "describe_privileges", "create view
sys.describe_privileges as select case when o.tpe is null and
pc.privilege_code_name = 'SELECT' then 'COPY FROM' when o.tpe is null and
pc.privilege_code_name = 'UPDATE' then 'COPY INTO' else o.nme end o_nme,
coalesce(o.tpe, 'GLOBAL') o_tpe, pc.privilege_code_name p_nme, a.name a_nme,
g.name g_nme, p.grantable grantable from sys.privileges p left join (select
t.id, s.name || '.' || t.name , 'TABLE' from sys.schemas s, sys.tables t where
s.id = t.schema_id union all select c.id, s.name || '.' || t.name || '.' ||
c.name, 'COLUMN' from sys.schemas s, sys.tables t, sys.columns c where s.id =
t.schema_id and t.id = c.table_id union all select f.id, f.nme, f.tpe from
sys.fully_qualified_functions f) o(id, nme, tpe) on o.id = p.obj_id,
sys.privilege_codes pc, auths a, auths g where p.privileges =
pc.privilege_code_id and p.auth_id = a.id and p.grantor = g.id;", "VIEW", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "describe_sequences", "create view
sys.describe_sequences as select s.name sch, seq.name seq, seq.\"start\" s,
get_value_for(s.name, seq.name) rs, seq.\"minvalue\" mi, seq.\"maxvalue\" ma,
seq.\"increment\" inc, seq.\"cacheinc\" cache, seq.\"cycle\" cycle, case when
seq.\"minvalue\" = -9223372036854775807 and seq.\"increment\" > 0 and
seq.\"start\" = 1 then true else false end nomin, case when seq.\"maxvalue\" =
9223372036854775807 and seq.\"increment\" < 0 and seq.\"start\" = -1 then true
else false end nomax, case when seq.\"minvalue\" = 0 and seq.\"increment\" > 0
then null when seq.\"minvalue\" <> -9223372036854775807 then seq.\"minvalue\"
else case when seq.\"increment\" < 0 then null else case when seq.\"start\" = 1
then null else seq.\"maxvalue\" end end end rmi, case when seq.\"maxvalue\" = 0
and seq.\"increment\" < 0 then null when seq.\"maxvalue\" <>
9223372036854775807 then seq.\"maxvalue\" else case when seq.\"increment\" > 0
then null else case w
hen seq.\"start\" = -1 then null else seq.\"maxvalue\" end end end rma from
sys.sequences seq, sys.schemas s where s.id = seq.schema_id and s.name <> 'tmp'
order by s.name, seq.name;", "VIEW", true, "COMMIT", "WRITABLE",
NULL ]
-[ "sys._tables", "sys", "describe_tables", "create view
sys.describe_tables as select t.id o, s.name sch, t.name tab,
ts.table_type_name typ, (select ' (' || group_concat(sys.dq(c.name) || ' ' ||
sys.describe_type(c.type, c.type_digits, c.type_scale) || ifthenelse(c.\"null\"
= 'false', ' NOT NULL', '') , ', ') || ')' from sys._columns c where c.table_id
= t.id) col, case ts.table_type_name when 'REMOTE TABLE' then
sys.get_remote_table_expressions(s.name, t.name) when 'MERGE TABLE' then
sys.get_merge_table_partition_expressions(t.id) when 'VIEW' then
sys.schema_guard(s.name, t.name, t.query) else '' end opt from sys.schemas s,
sys.table_types ts, sys.tables t where ts.table_type_name in ('TABLE', 'VIEW',
'MERGE TABLE', 'REMOTE TABLE', 'REPLICA TABLE', 'UNLOGGED TABLE') and t.system
= false and s.id = t.schema_id and ts.table_type_id = t.type and s.name <>
'tmp';", "VIEW", true, "COMMIT", "WRITABLE", NULL ]
+[ "sys._tables", "sys", "describe_tables", "create view
sys.describe_tables as select t.id o, s.name sch, t.name tab,
ts.table_type_name typ, (select ' (' || group_concat(sys.dq(c.name) || ' ' ||
sys.describe_type(c.type, c.type_digits, c.type_scale) || ifthenelse(c.\"null\"
= false, ' NOT NULL', '') , ', ') || ')' from sys._columns c where c.table_id =
t.id) col, case ts.table_type_name when 'REMOTE TABLE' then
sys.get_remote_table_expressions(s.name, t.name) when 'MERGE TABLE' then
sys.get_merge_table_partition_expressions(t.id) when 'VIEW' then
sys.schema_guard(s.name, t.name, t.query) else '' end opt from sys.schemas s,
sys.table_types ts, sys.tables t where ts.table_type_name in ('TABLE', 'VIEW',
'MERGE TABLE', 'REMOTE TABLE', 'REPLICA TABLE', 'UNLOGGED TABLE') and t.system
= false and s.id = t.schema_id and ts.table_type_id = t.type and s.name <>
'tmp';", "VIEW", true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "describe_triggers", "create view
sys.describe_triggers as select s.name sch, t.name tab, tr.name tri,
tr.statement def from sys.schemas s, sys.tables t, sys.triggers tr where s.id =
t.schema_id and t.id = tr.table_id and not t.system;", "VIEW", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "describe_user_defined_types", "create view
sys.describe_user_defined_types as select s.name sch, t.sqlname sql_tpe,
t.systemname ext_tpe from sys.types t join sys.schemas s on t.schema_id = s.id
where t.eclass = 18 and ((s.name = 'sys' and t.sqlname not in ('geometrya',
'mbr', 'url', 'inet', 'json', 'uuid', 'xml', 'inet4', 'inet6')) or (s.name <>
'sys'));", "VIEW", true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "dump_add_schemas_to_users", "create view
sys.dump_add_schemas_to_users as select 'ALTER USER ' || sys.dq(ui.name) || '
SET SCHEMA ' || sys.dq(s.name) || ';' stmt, s.name schema_name, ui.name
user_name from sys.db_user_info ui, sys.schemas s where ui.default_schema =
s.id and ui.name <> 'monetdb' and ui.name <> '.snapshot' and s.name <> 'sys';",
"VIEW", true, "COMMIT", "WRITABLE", NULL ]
@@ -588,7 +588,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 ]
@@ -1694,23 +1694,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 ]
@@ -2882,7 +2882,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 ]
@@ -2890,13 +2890,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" ]
@@ -2923,7 +2923,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" ]
@@ -2982,7 +2982,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" ]
@@ -3121,7 +3121,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" ]
@@ -3210,7 +3210,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" ]
@@ -3477,7 +3477,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" ]
@@ -4400,7 +4400,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" ]
@@ -4422,7 +4422,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" ]
@@ -4444,7 +4444,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"
]
@@ -4509,7 +4509,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 ]
@@ -4531,7 +4531,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
]
@@ -4553,7 +4553,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 ]
@@ -4593,13 +4593,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
]
@@ -4706,11 +4706,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 ]
[ "grant on function", "json", "filter", "public", "EXECUTE",
"monetdb", 0 ]
@@ -5186,26 +5186,26 @@ select 'null in fkeys.delete_action', de
% .%1, .s, .q, .q, .q, .q, .q, .q, .q, . #
table_name
% %1, name, name, start, minvalue, maxvalue, increment,
cacheinc, cycle, comment # name
% varchar, varchar, varchar, bigint, bigint, bigint, bigint,
bigint, boolean, varchar # type
-% 0, 0, 0, 1, 1, 1, 1, 1, 5, 0 #
length
+% -1, -1, -1, -1, -1, -1, -1, -1, 5, -1 #
length
% .%12 # table_name
% %12 # name
% bigint # type
-% 1 # length
+% -1 # length
[ 0 ]
% .%1 # table_name
% %1 # name
% bigint # type
-% 1 # length
+% -1 # length
[ 0 ]
% .%1, .t, .g, ., ., ., .g, .g, .g, .g #
table_name
% %1, name, name, time, orientation, event, old_name,
new_name, condition, statement # name
% varchar, varchar, varchar, varchar, varchar,
varchar, varchar, varchar, varchar, varchar # type
-% 12, 7, 21, 5, 9, 6, 0, 0, 0, 110 #
length
+% -1, -1, -1, -1, -1, -1, -1, -1, -1, -1 #
length
[ "sys.triggers", "schemas", "system_update_schemas",
"AFTER", "STATEMENT", "UPDATE", NULL, NULL, NULL, "create
trigger system_update_schemas after update on sys.schemas for each statement
call sys_update_schemas();" ]
% .%51, .s, .t, .t, .t, .t, .t, . # table_name
% %51, name, systemname, sqlname, digits, scale, radix, eclass
# name
% varchar, varchar, varchar, varchar, int, int,
int, varchar # type
-% 9, 3, 9, 14, 2, 1, 2, 12 # length
+% -1, -1, -1, -1, -1, -1, -1, -1 # length
[ "sys.types", "sys", "bat", "table", 0, 0, 0, "TABLE"
]
[ "sys.types", "sys", "bit", "boolean", 1, 0, 2, "BIT"
]
[ "sys.types", "sys", "blob", "blob", 0, 0, 0, "BLOB" ]
@@ -5243,11 +5243,11 @@ select 'null in fkeys.delete_action', de
% .%1, .a1, .a2 # table_name
% %1, name, name # name
% varchar, varchar, varchar # type
-% 0, 0, 0 # length
+% -1, -1, -1 # length
% .%1, .keywords # table_name
% %1, keyword # name
% varchar, varchar # type
-% 12, 17 # length
+% -1, -1 # length
[ "sys.keywords", "ADD" ]
[ "sys.keywords", "ADMIN" ]
[ "sys.keywords", "AFTER" ]
@@ -5383,7 +5383,6 @@ select 'null in fkeys.delete_action', de
[ "sys.keywords", "ISOLATION" ]
[ "sys.keywords", "JOIN" ]
[ "sys.keywords", "KEY" ]
-[ "sys.keywords", "LANGUAGE" ]
[ "sys.keywords", "LARGE" ]
[ "sys.keywords", "LAST" ]
[ "sys.keywords", "LATERAL" ]
@@ -5551,7 +5550,7 @@ select 'null in fkeys.delete_action', de
% .%1, .table_types, .table_types # table_name
% %1, table_type_id, table_type_name # name
% varchar, smallint, varchar # type
-% 15, 2, 22 # length
+% -1, -1, -1 # length
[ "sys.table_types", 0, "TABLE" ]
[ "sys.table_types", 1, "VIEW" ]
[ "sys.table_types", 3, "MERGE TABLE" ]
@@ -5566,7 +5565,7 @@ select 'null in fkeys.delete_action', de
% .%1, .function_types, .function_types # table_name
% %1, function_type_name, function_type_keyword # name
% varchar, varchar, varchar # type
-% 18, 26, 15 # length
+% -1, -1, -1 # length
[ "sys.function_types", "Aggregate function", "AGGREGATE" ]
[ "sys.function_types", "Filter function", "FILTER FUNCTION"
]
[ "sys.function_types", "Function returning a table", "FUNCTION"
]
@@ -5578,19 +5577,14 @@ select 'null in fkeys.delete_action', de
% .%1, .function_languages, .function_languages # table_name
% %1, language_name, language_keyword # name
% varchar, varchar, varchar # type
-% 22, 10, 7 # length
+% -1, -1, -1 # length
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
