Changeset: a15180d06a92 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/a15180d06a92
Modified Files:
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
Branch: unlogged
Log Message:
Fix test output.
diffs (60 lines):
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
@@ -471,7 +471,7 @@ select 'null in value_partitions.value',
[ "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') 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')) 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 ]
@@ -4821,6 +4821,7 @@ select 'null in value_partitions.value',
[ "sys.table_types", 3, "MERGE TABLE" ]
[ "sys.table_types", 5, "REMOTE TABLE" ]
[ "sys.table_types", 6, "REPLICA TABLE" ]
+[ "sys.table_types", 7, "UNLOGGED TABLE" ]
[ "sys.table_types", 10, "SYSTEM TABLE" ]
[ "sys.table_types", 11, "SYSTEM VIEW" ]
[ "sys.table_types", 20, "GLOBAL TEMPORARY TABLE" ]
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
@@ -471,7 +471,7 @@ select 'null in value_partitions.value',
[ "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') 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')) 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 ]
@@ -4821,6 +4821,7 @@ select 'null in value_partitions.value',
[ "sys.table_types", 3, "MERGE TABLE" ]
[ "sys.table_types", 5, "REMOTE TABLE" ]
[ "sys.table_types", 6, "REPLICA TABLE" ]
+[ "sys.table_types", 7, "UNLOGGED TABLE" ]
[ "sys.table_types", 10, "SYSTEM TABLE" ]
[ "sys.table_types", 11, "SYSTEM VIEW" ]
[ "sys.table_types", 20, "GLOBAL TEMPORARY TABLE" ]
diff --git a/sql/test/emptydb/Tests/check.stable.out.int128
b/sql/test/emptydb/Tests/check.stable.out.int128
--- a/sql/test/emptydb/Tests/check.stable.out.int128
+++ b/sql/test/emptydb/Tests/check.stable.out.int128
@@ -471,7 +471,7 @@ select 'null in value_partitions.value',
[ "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') 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')) 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 ]
@@ -4954,6 +4954,7 @@ select 'null in value_partitions.value',
[ "sys.table_types", 3, "MERGE TABLE" ]
[ "sys.table_types", 5, "REMOTE TABLE" ]
[ "sys.table_types", 6, "REPLICA TABLE" ]
+[ "sys.table_types", 7, "UNLOGGED TABLE" ]
[ "sys.table_types", 10, "SYSTEM TABLE" ]
[ "sys.table_types", 11, "SYSTEM VIEW" ]
[ "sys.table_types", 20, "GLOBAL TEMPORARY TABLE" ]
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
